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(precision). If no precision is given, the data type is TIMESTAMP(3).

• The return value is limited to microsecond precision, even if precision is greater than 6.

• 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, SYSTIMESTAMP(6);