Skip to main content

Categories: System, Date/Time

CURRENT_TIMESTAMP

Returns the current TIMESTAMP for the system.

Syntax​

CURRENT_TIMESTAMP([precision int32]) → TIMESTAMP​

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

Examples

CURRENT_TIMESTAMP example 
SELECT CURRENT_TIMESTAMP()
-- 2021-06-24 06:11:51.123
SELECT CURRENT_TIMESTAMP(6)
-- 2021-06-24 06:11:51.123456
SELECT CURRENT_TIMESTAMP(9)
-- 2021-06-24 06:11:51.123456789