MySQL Forums :: Newbie :: TIMESTAMPADD and Daylight Savings Time issue???


Advanced Search

TIMESTAMPADD and Daylight Savings Time issue???
Posted by: Doug Furciniti ()
Date: May 02, 2012 11:28AM

I have recently come across an issue with the TIMESTAMPADD function. I am running version 5.5 and when I execute the following statement I get a result that is not valid. I have looked for information about this and it suposedly was fixed in 2009.

See below:

SELECT TIMESTAMPADD(HOUR,120,'2012-03-06 02:05:00');

Returns:

2012-03-11 02:05:00

Unfortunately, there is no 02:05 on 03-11 due to daylight savings. I was expecting that the return value would have taken that into account and returned:

2012-03-11 03:05:00

What am I doing wrong?

Options: ReplyQuote


Subject Written By Posted
TIMESTAMPADD and Daylight Savings Time issue??? Doug Furciniti 05/02/2012 11:28AM
Re: TIMESTAMPADD and Daylight Savings Time issue??? Peter Brawley 05/02/2012 11:46AM
Re: TIMESTAMPADD and Daylight Savings Time issue??? Rick James 05/04/2012 08:40AM
Re: TIMESTAMPADD and Daylight Savings Time issue??? Peter Brawley 05/04/2012 12:20PM
Re: TIMESTAMPADD and Daylight Savings Time issue??? Doug Furciniti 05/04/2012 01:13PM
Re: TIMESTAMPADD and Daylight Savings Time issue??? Peter Brawley 05/04/2012 01:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.