Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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