Datetime Functions ​

This section covers functions that work with datetime data types and literals.

In This Section

• ADD_MONTHS

• AGE

• AT TIME ZONE

• CURRENT_DATE

• CURRENT_TIMESTAMP

• CURRENT_UTC_TIMESTAMP()

• DATEADD

• DATEDIFF

• DATENAME

• DATE_PART

• DATE_TRUNC

• DAY

• DAYS_BETWEEN

• EOMONTH

• EXTRACT

• GETDATE

• JUSTIFY_DAYS, _HOURS, _INTERVAL

• LAST_DAY

• LOCALTIME

• LOCALTIMESTAMP

• MAKE_DATE

• MAKE_INTERVAL

• MAKE_TIME

• MAKE_TIMESTAMP

• MAKE_TIMESTAMPTZ

• MONTH

• MONTHS_BETWEEN

• NEXT_DAY

• NOW()

• OVERLAPS

• TIMEOFDAY()

• TIMEZONE

• YEAR

• Supported Dateparts

Parent topic:SQL Functions and Operators