NOW

Syntax

NOW([scale])

Purpose

You can call this function to return 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 (0.00 sec)