Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

Oracle PL/SQL Syntax & Examples [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: DATE

Definition:

Related Code Snippets:

Date Functions: Return next date - Takes a date and returns the next date, a simple skeleton for d...
Date Functions: Add Months - The add_months function returns a date plus n months.
Date Functions: Current_date - The current_date function returns the current date in the time zone...
Date Functions: Round (date) - The round function returns a date rounded to a specific unit of measure
Date Functions: To_Date - The to_date function converts a string to a date.
Date Functions: TRUNC (date) - The trunc function returns a date truncated to a specific unit of m...
Date Math Sample 1 - An example of subtracting dates to get the difference between them.
UPDATE - A sample of an update statement.
Date functions: Current Date
Date Functions: Add and Subtract from Dates - Adding and subtracting from date values.
Date Functions: ADD_MONTHS - Add a month or months to a given date.
Date functions: CURRENT_DATE - The CURRENT_DATE function returns the current date in the session t...
Date Functions: DUMP - DUMP returns a VARCHAR2 value containing the datatype code, length in bytes...
Date Functions: GREATEST - Returns the latest date value.
Date Functions: LEAST - Returns the earliest date.
Date Functions: INTERVAL - Interval to adjust date-time.
Date Functions: LAST_DAY - Returns the last date (not day) of a given month.
Date Functions: LENGTH - Returns length in characters.
Date Functions: LENGTHB - Similar to LENGTH, but returns the length in bytes.
Date Functions: MAX - Returns the latest date.
Date Functions: MIN - Returns the earliest date.
Date Functions: MONTHS_BETWEEN - Returns the months in between (separating) two given dates.
Date Functions: NEW_TIME - Returns the date and time in time zone zone2 when date and time in time...
Date Functions: NEXT_DAY - Gives you the date of next specified date following a given date.
Date Functions: ROUND - Returns date rounded to the unit specified by the format model. If you omi...

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: