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 WITH LOCAL TIME ZONE.

• Other functions for the current moment:

  • CURRENT_TIMESTAMP or NOW

  • SYSTIMESTAMP

Example

SELECT LOCALTIMESTAMP;