Oracle PL/SQL Category

Quick Search:


	CODE Oracle PL/SQL Code Library


	FORUM Oracle Discussion & Chat

Jump to:

To view the original pages (which were formerly called "Morgan's Library"), you can click here.

Date Functions: DUMP - DUMP returns a VARCHAR2 value containing the datatype code, lengt...

Date Functions: EXTRACT - Extracts and returns the value of a specified datetime field f...

Date Functions: GREATEST - Returns the latest date value.

Date Functions: INTERVAL - Interval to adjust date-time.

Date Functions: LAST_DAY - Returns the last date (not day) of a given month.

Date Functions: LEAST - Returns the earliest date.

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 ti...

Date Functions: NEXT_DAY - Gives you the date of next specified date following a given date.

Date Functions: NUMTODSINTERVAL - Converts a number to an INTERVAL DAY TO SECOND literal.

Date Functions: NUMTOYMINTERVAL - Converts n to an INTERVAL YEAR TO MONTH literal.

Date Functions: Return next date - Takes a date and returns the next date, a simple skel...

Date Functions: ROUND - Returns date rounded to the unit specified by the format model. ...

Date Functions: Round (date) - The round function returns a date rounded to a specific u...

Date Functions: SYSDATE - Returns the current date and time set for the operating system...

Date Functions: TO_CHAR - Converts DATE and TIMESTAMP to VARCHAR2 with the specified ...

Date Functions: To_Date - The to_date function converts a string to a date.

Date Functions: TO_DSINTERVAL - Converts a string to an INTERVAL DAY TO SECOND DataType.

Date Functions: TO_NCHAR - Converts a DATE or TIMESTAMP from the database character set...

Date Functions: TO_YMINTERVAL - Converts a string to an Interval Year to Month data type.

Date Functions: TRUNC - Convert a date to the date it would be at midnight. Using the...

Date Functions: TRUNC (date) - The trunc function returns a date truncated to a specific...

Date Functions: WHERE Clause Joins - Examples of using dates in WHERE Clause Joins.

Date Math Sample 1 - An example of subtracting dates to get the difference between them.

Date: Find first day of the month - Returns the first day of a given month.

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