CURRENT_TIMESTAMP

Purpose

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

Syntax

current_timestamp::=

Current Timestamp

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:

Example

SELECT CURRENT_TIMESTAMP;

CURRENT_TIMESTAMP
-------------------
1999-12-31 23:59:59