Mega Code Archive

 

Categories / MySQL / Date Time

 

Determining the Current Date or Time

mysql> mysql> SELECT NOW( ), CURDATE( ), CURTIME( ); +---------------------+------------+------------+ | NOW( )              | CURDATE( ) | CURTIME( ) | +---------------------+------------+------------+ | 2011-10-03 13:05:45 | 2011-10-03 | 13:05:45   | +---------------------+------------+------------+ 1 row in set (0.00 sec) mysql>