8.9 Datetime functions

This section describes the functions and specification formats of the datetime functions.

Organization of this section

• 8.9.1 DATEDIFF

• 8.9.2 DAYOFWEEK

• 8.9.3 DAYOFYEAR

• 8.9.4 EXTRACT

• 8.9.5 GETAGE

• 8.9.6 LASTDAY

• 8.9.7 ROUND

• 8.9.8 TIMESTAMPADD

• 8.9.9 TIMESTAMPDIFF

• 8.9.10 TIMEZONE

• 8.9.11 TRUNC

To Page Top