Syntax
LOCALTIMESTAMP([scale])
Purpose
You can call this function to return the current date and time. scale specifies the precision of microseconds. The valid value is any integer 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 (0.00 sec)