Syntax
NOW([scale])
Purpose
NOW() returns the current date and time based on the specified time zone. This function is an alias for CURRENT_TIMESTAMP().
scale specifies the precision of microseconds. The valid value is any integer ranging from 0 to 6. Default value: 0.
Examples
obclient> SELECT NOW(6);
+----------------------------+
| NOW(6) |
+----------------------------+
| 2021-07-20 16:30:54.816317 |
+----------------------------+
1 row in set