SYSTIMESTAMP

Purpose

This function returns the current timestamp, interpreted in the current database time zone.

Usage Notes

• The return value is of data type TIMESTAMP.

• For more information about the database time zone, refer to the function DBTIMEZONE.

• Other functions for the current time:

  • CURRENT_TIMESTAMP or NOW

  • LOCALTIMESTAMP

Example

SELECT SYSTIMESTAMP;