Oracle Date Functions

NEW_TIME

Converts a date from time zone1 to a date in time zone2

EXTRACT

Extracts a value from a date or interval value

ROUND

Returns a date rounded to a specific unit of measure

TRUNC

Returns a date truncated to a specific unit of measure

ADD_MONTHS

Returns a date with a specified number of months added

CURRENT_TIMESTAMP

Returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command

LOCALTIMESTAMP

Returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command

CURRENT_DATE

Returns the current date in the time zone of the current SQL session as set by the ALTER SESSION command

SESSIONTIMEZONE

Returns the current session's time zone as a time zone offset or a time zone region name

SYSTIMESTAMP

Returns the current system date and time (including fractional seconds and time zone) on your local database

SYSDATE

Returns the current system date and time on your local database

NEXT_DAY

Returns the first weekday that is greater than a date

LAST_DAY

Returns the last day of the month based on a date value

MONTHS_BETWEEN

Returns the number of months between date1 and date2

TZ_OFFSET

Returns the time zone offset of a value

DBTIMEZONE

returns the database time zone as a time zone offset or a time zone region name