Time functions

Time functions determine

• current date (CURRENT_DATE)

• current time (CURRENT_TIME(3) or LOCALTIME(3))

• time stamp with the current date and current time (CURRENT_TIMESTAMP(3) or LOCALTIMESTAMP(3))

• the Julian Day number corresponding to an integer value (DATE_OF_JULIAN_DAY) (see also the inverse function JULIAN_DAY_OF_DATE on "Numeric functions").

LOCALTIMESTAMP(3) and CURRENT_TIMESTAMP(3) are equivalent in SESAM/SQL, as are LOCALTIME(3) and CURRENT_TIME(3). In the SQL standard, CURRENT_TIMESTAMP and CURRENT_TIME are provided for a language extension making it possible to calculate on the basis of different time zones.