Oracle Date/Time Functions

18 functions

SYSDATESYSDATE

Returns the current date and time of the database server.

SYSTIMESTAMPSYSTIMESTAMP

Returns the current timestamp with time zone of the database server.

CURRENT_DATECURRENT_DATE

Returns the current date in the session time zone.

CURRENT_TIMESTAMPCURRENT_TIMESTAMP

Returns the current timestamp in the session time zone.

ADD_MONTHSADD_MONTHS(date, n)

Adds n months to a date.

MONTHS_BETWEENMONTHS_BETWEEN(d1, d2)

Returns the number of months between two dates.

LAST_DAYLAST_DAY(date)

Returns the last day of the month.

NEXT_DAYNEXT_DAY(date, weekday)

Returns the next occurrence of the specified weekday.

ROUNDROUND(date [, fmt])

Rounds a date to the specified unit.

TRUNCTRUNC(date [, fmt])

Truncates a date to the specified unit.

EXTRACTEXTRACT(field FROM date)

Extracts a specific field from a date/time value.

TO_DATETO_DATE(str, fmt)

Converts a string to a date.

TO_TIMESTAMPTO_TIMESTAMP(str, fmt)

Converts a string to a TIMESTAMP.

TO_CHARTO_CHAR(date, fmt)

Converts a date to a formatted string.

FROM_TZFROM_TZ(ts, tz_str)

Assigns a time zone to a timestamp.

TZ_OFFSETTZ_OFFSET(tz_name)

Returns the UTC offset of a time zone.

NUMTODSINTERVALNUMTODSINTERVAL(n, unit)

Converts a number to a day-time interval.

NUMTOYMINTERVALNUMTOYMINTERVAL(n, unit)

Converts a number to a year-month interval.