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(p) WITH LOCAL TIME ZONE where p = precision in number of fractional digits.

    If no precision is given, the data type is TIMESTAMP(3) WITH LOCAL TIME ZONE.

  • The return value is limited to microsecond precision, even if precision is greater than 6.

  • Exasol versions before 8.32.0 are limited to millisecond precision TIMESTAMP(3).

  • The function NOW is an alias for CURRENT_TIMESTAMP(3).

  • Other functions for the current moment:

Example

Copy 
SELECT CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(6);