Skip to main content

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