Mega Code Archive

 

Categories / MySQL / Date Time

 

What time will it be in 60 hours

mysql> mysql> SELECT NOW( ), DATE_ADD(NOW( ),INTERVAL 60 HOUR); +---------------------+-----------------------------------+ | NOW( )              | DATE_ADD(NOW( ),INTERVAL 60 HOUR) | +---------------------+-----------------------------------+ | 2011-10-03 13:05:47 | 2011-10-06 01:05:47               | +---------------------+-----------------------------------+ 1 row in set (0.00 sec) mysql> mysql>