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/Time Calculations: Get seconds between dates - Calculates the number of seconds bet... Date: Find first day of the month - Returns the first day of a given month.