NOW

Declaration

NOW([scale])

Description

Returns the current date and time, taking into account the timezone setting. This function is an alias for CURRENT_TIMESTAMP().

scale specifies the precision of the microseconds part, which must be an integer between 0 and 6. The default value is 0.

Examples

SELECT NOW(6);
+----------------------------+
| NOW(6)                     |
+----------------------------+
| 2025-12-17 17:13:38.244320 |
+----------------------------+
1 row in set (0.001 sec)