Syntax
LOCALTIME
LOCALTIME([scale])
Purpose
You can call this function to return 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 (0.00 sec)
obclient> SELECT LOCALTIME(6);
+----------------------------+
LOCALTIME(6)
+----------------------------+
2021-08-25 17:20:41.358574
+----------------------------+
1 row in set (0.00 sec)