Mega Code Archive

 

Categories / MySQL / Date Time

 

Get the current full date object, current date nd time

mysql> mysql> SELECT NOW(), CURDATE(), CURTIME(); +---------------------+------------+-----------+ | NOW()               | CURDATE()  | CURTIME() | +---------------------+------------+-----------+ | 2011-10-04 11:09:17 | 2011-10-04 | 11:09:17  | +---------------------+------------+-----------+ 1 row in set (0.00 sec)