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.