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. The valid value is any integer ranging from 0 to 6. Default value: 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