Wednesday, September 11, 2013

How to add time in mysql ?

SELECT ADDTIME('1984-05-31 23:59:59', '0 0:15:01');

Here you can see 23 Hrs 59 Minutes and 59 Seconds is added with 0 Hrs, 15 Minutes and 01 Seconds

The Result is '1984-06-01 00:15:00'

Oops My Birthday....

No comments:

Post a Comment