NOW

Purpose

This function returns the current timestamp, interpreted in the current session time zone.

Usage Notes

• The return value is of data type TIMESTAMP(3) WITH LOCAL TIME ZONE.
• This function is an alias for CURRENT_TIMESTAMP(3).
• Other functions for the current moment:
  • LOCALTIMESTAMP
  • SYSTIMESTAMP

Example

SELECT NOW() NOW;