CURRENT_TIMESTAMP

Declaration

CURRENT_TIMESTAMP([scale])

Description

Returns the date and time in the current time zone.

scale specifies the precision of the microseconds part, which is an integer ranging from 0 to 6. The default value is 0.

Examples

SELECT CURRENT_TIMESTAMP(6);
+----------------------------+
| CURRENT_TIMESTAMP(6)       |
+----------------------------+
| 2025-12-17 16:13:31.520977 |
+----------------------------+
1 row in set (0.001 sec)