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

  If no precision is given, the data type is TIMESTAMP(3).

• 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).

• Other functions for the current moment:

  • CURRENT_TIMESTAMP or NOW

  • SYSTIMESTAMP

Example

SELECT LOCALTIMESTAMP, LOCALTIMESTAMP(6);