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