CURRENT_TIMESTAMP

2024-12-02 03:48:26  Updated

Syntax

CURRENT_TIMESTAMP([scale])

Purpose

CURRENT_TIMESTAMP() returns the datetime of the current time zone.

scale specifies the precision of microseconds. Valid values are any integers ranging from 0 to 6. The default value is 0.

Examples

obclient> SELECT CURRENT_TIMESTAMP(6);
+----------------------------+
| CURRENT_TIMESTAMP(6)       |
+----------------------------+
| 2018-05-05 11:35:39.177764 |
+----------------------------+
1 row in set

Contact Us