LOCALTIMESTAMP

Purpose

This function returns the current timestamp, interpreted in the current session 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.

• Other functions for the current moment:

  • CURRENT_TIMESTAMP or NOW

  • SYSTIMESTAMP

Example

SELECT LOCALTIMESTAMP, LOCALTIMESTAMP(6);