Syntax
LOCALTIME
LOCALTIME([scale])
Purpose
LOCALTIME() returns the current date and time. LOCALTIME and LOCALTIME() are synonyms of NOW().
scale specifies the precision of the microsecond part. Valid values are any integers ranging from 0 to 6. The default value is 0.
Examples
obclient> SELECT LOCALTIME(0);
+---------------------+
| LOCALTIME(0) |
+---------------------+
| 2021-08-25 17:20:31 |
+---------------------+
1 row in set
obclient> SELECT LOCALTIME(6);
+----------------------------+
| LOCALTIME(6) |
+----------------------------+
| 2021-08-25 17:20:41.358574 |
+----------------------------+
1 row in set