Skip to main content

Categories: System

LOCALTIMESTAMP

Returns the current timestamp for the system.

Syntax

LOCALTIMESTAMP([precision int32]) → timestamp

  • precision (optional): The number of digits of precision to which the timestamp value is rounded.

Examples

LOCALTIMESTAMP example
SELECT LOCALTIMESTAMP
-- 2021-06-29 05:17:44.123
SELECT LOCALTIMESTAMP(6)
-- 2021-06-29 05:17:44.123456
SELECT LOCALTIMESTAMP(9)
-- 2021-06-29 05:17:44.123456789