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
