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. Valid values are any integers ranging 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