Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. Current Date and Time
There are several methods for obtaining the current date and time:
NOW()/SYSDATE()/CURRENT_TIMESTAMP
CURDATE()/CURRENT_DATE
CURTIME()/CURRENT_TIME

mysql>
mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2007-07-23 18:58:25 |
+---------------------+
1 row in set (0.00 sec)
mysql> SELECT NOW()+0;
+-----------------------+
| NOW()+0               |
+-----------------------+
| 20070723185825.000000 |
+-----------------------+
1 row in set (0.00 sec)
mysql>