Syntax
NOW([scale])
Purpose
Returns the current date and time, taking into account the time zone setting. This function is an alias for CURRENT_TIMESTAMP().
scale specifies the precision of the microseconds part, which can be an integer from 0 to 6. The default value is 0.
Examples
obclient> SELECT NOW(6);
+----------------------------+
| NOW(6) |
+----------------------------+
| 2021-07-20 16:30:54.816317 |
+----------------------------+
1 row in set