Outdated Version

You are viewing an older version of this section. View current production version.

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.

Examples

select current_timestamp(), now();
+---------------------+---------------------+
| current_timestamp() | now()               |
+---------------------+---------------------+
| 2015-03-03 21:50:04 | 2015-03-03 21:50:04 |
+---------------------+---------------------+

Related Topics