LOCALTIMESTAMP

声明

LOCALTIMESTAMP([scale])

说明

返回当前日期和时间，scale 表示微秒部分精度，有效值为 0 到 6 的整数。LOCALTIMESTAMP 和 LOCALTIMESTAMP() 是 NOW() 的同义词。

示例

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)