Adding Datetimes in MySQL

Question

I am wondering if anyone can suggest solutions for adding together datetimes in mysql?

I have a scheduler datetime, and want to add another datetime which specifies a period like '2012-03-23 10:00:00' + '0000-00-00 01:01:01' Should of course produce '2012-03-23 11:01:01'.

MySQL doesn't seem to like doing this with any of the DATE_ADD/ADDDATE variants.

Hope there are some solutions for this.

What is the datatype of the second "datetime"? '0000-00-00 01:01:01' is not a datetime that can be stored in the database since month 0/day 0 does not exist. — Joachim Isaksson
– Joachim Isaksson, Commented Mar 23, 2012 at 11:21

Pedro Ferreira · Accepted Answer · 2012-03-23 10:23:23Z

1

Visit mysql addDate

The syntax is:

mysql> SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');
   -> '2008-01-02 01:01:01.000001'
mysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
   -> '03:00:01.999997'

answered Mar 23, 2012 at 10:23

Pedro Ferreira

6493 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Milan Halada · Accepted Answer · 2012-03-23 10:25:26Z

0

Try

DATE_ADD(DATE_ADD(DATE_ADD(NOW(), INTERVAL 1 HOUR), INTERVAL 1 MINUTE), INTERVAL 1 SECOND)

Works for me...

answered Mar 23, 2012 at 10:25

Milan Halada

1,9441 gold badge18 silver badges28 bronze badges

Collectives™ on Stack Overflow

Adding Datetimes in MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related