Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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>