Mega Code Archive

 

Categories / MySQL / Date Time

 

CURDATE(), CURRENT_DATE(), CURTIME(), CURRENT_TIME(), CURRENT_TIMESTAMP(), and NOW() Functions

mysql> mysql> mysql> SELECT CURDATE(); +------------+ | CURDATE()  | +------------+ | 2011-10-03 | +------------+ 1 row in set (0.00 sec) mysql> SELECT CURTIME(); +-----------+ | CURTIME() | +-----------+ | 20:56:41  | +-----------+ 1 row in set (0.00 sec) mysql> SELECT NOW(); +---------------------+ | NOW()               | +---------------------+ | 2011-10-03 20:56:41 | +---------------------+ 1 row in set (0.00 sec) mysql>