Syntax
LOCALTIME
LOCALTIME([scale])
Purpose
Returns the current date and time. LOCALTIME and LOCALTIME() are synonyms for NOW().
scale specifies the precision of the microseconds part, which is an integer 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