LOCALTIMESTAMP

Declaration

LOCALTIMESTAMP([scale])

Description

Returns the current date and time, with scale indicating the precision of the microseconds part, which can be an integer from 0 to 6. LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms for NOW().

Examples

SELECT LOCALTIMESTAMP,LOCALTIMESTAMP(0),LOCALTIMESTAMP(6);
+---------------------+---------------------+----------------------------+
| LOCALTIMESTAMP      | LOCALTIMESTAMP(0)   | LOCALTIMESTAMP(6)          |
+---------------------+---------------------+----------------------------+
| 2025-12-17 16:56:51 | 2025-12-17 16:56:51 | 2025-12-17 16:56:51.769355 |
+---------------------+---------------------+----------------------------+
1 row in set (0.001 sec)