Categories:

Context Functions (General)

LOCALTIMESTAMP

Returns the current timestamp for the system in the local time zone.

ANSI-compliant alias for CURRENT_TIMESTAMP.

Syntax

LOCALTIMESTAMP( [ <fract_sec_precision> ] )

LOCALTIMESTAMP
Copy

Arguments

fract_sec_precision

This optional argument indicates the precision with which to report the time. For example, a value of 3 says to use 3 digits after the decimal point (i.e. to specify the time with a precision of milliseconds).

The default precision is 9 (nanoseconds).

Valid values range from 0 - 9. However, most platforms do not support true nanosecond precision; the precision that you get might be less than the precision you specify. In practice, precision is usually approximately milliseconds (3 digits) at most.

Note

Fractional seconds are only displayed if they have been explicitly set in the TIMESTAMP_OUTPUT_FORMAT parameter for the session (e.g. 'YYYY-MM-DD HH24:MI:SS.FF').

Returns

Returns the current system time. The data type of the returned value is TIMESTAMP_LTZ.

Usage notes

  • The setting of the TIMEZONE parameter affects the return value. The returned timestamp is in the time zone for the session.

  • The setting of the TIMESTAMP_TYPE_MAPPING parameter affects the return value. The returned timestamp is in the timestamp type for the session.

  • Do not use the returned value for precise time ordering between concurrent queries (processed by the same virtual warehouse) because the queries might be serviced by different compute resources (in the warehouse).

  • To comply with ANSI standards, this function can be called without parentheses.

Examples

Show the current local time and local timestamp:

SELECT LOCALTIME(), LOCALTIMESTAMP();
Copy
+-------------+-------------------------------+
| LOCALTIME() | LOCALTIMESTAMP()              |
|-------------+-------------------------------|
| 07:58:09    | 2024-04-18 07:58:09.848 -0700 |
+-------------+-------------------------------+