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;