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