NOW

Returns the current date and time.

Syntax

NOW()

Return Type

Datetime object, returns date and time in “YYYY-MM-DD HH:MM:DD” format.

Examples

mysql> select NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2021-09-03 01:26:07 |
+---------------------+