CURRENT_TIMESTAMP

The CURRENT_TIMESTAMP function returns the current date and time from the system clock of the machine where the database is running.

Syntax

CURRENT_TIMESTAMP [p]

Remarks

•

CURRENT_TIMESTAMP has an optional precision argument (p), an integer that specifies the number of digits of fractional seconds.

•

The output is a TIMESTAMP with the format YYYY-MM-DD HH:MM:SS[.fff].

•

Valid values of p are 0 (no fractional seconds) to 3 (milliseconds). Values greater than 3 return 3 digits. For example, CURRENT_TIMESTAMP(3) and CURRENT_TIMESTAMP(8) both return a value like 2014-12-13 13:05:47.968.