CURRENT_TIMESTAMP
Returns the current date and time. NOW()
return a second precision result and NOW(6)
returns a microsecond precision result.
Syntax
CURRENT_TIMESTAMP() NOW() NOW(6) CURRENT_TIMESTAMP(6)
Return Type
Datetime object. The time zone will be in UTC unless the time zone has been converted. See Setting the Time Zone for more information.
Examples
SELECT CURRENT_TIMESTAMP(), NOW();
+---------------------+---------------------+ | CURRENT_TIMESTAMP() | NOW() | +---------------------+---------------------+ | 2015-03-03 21:50:04 | 2015-03-03 21:50:04 | +---------------------+---------------------+
Related Topics