Syntax
LOCALTIMESTAMP([scale])
Purpose
LOCALTIMESTAMP() returns the current date and time. scale specifies the precision of microseconds. Valid values are any integers ranging from 0 to 6. LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms of NOW().
Examples
obclient> SELECT LOCALTIMESTAMP,LOCALTIMESTAMP(0),LOCALTIMESTAMP(6);
+---------------------+---------------------+----------------------------+
| LOCALTIMESTAMP | LOCALTIMESTAMP(0) | LOCALTIMESTAMP(6) |
+---------------------+---------------------+----------------------------+
| 2021-08-25 17:17:08 | 2021-08-25 17:17:08 | 2021-08-25 17:17:08.952508 |
+---------------------+---------------------+----------------------------+
1 row in set