CURRENT_TIMESTAMP

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.

• The function NOW is an alias for CURRENT_TIMESTAMP.

• Other functions for the current moment:

  • LOCALTIMESTAMP

  • SYSTIMESTAMP

Example

SELECT CURRENT_TIMESTAMP;