MySQL Forums :: General :: DST and UTC_TIMESTAMP


Advanced Search

DST and UTC_TIMESTAMP
Posted by: Jim Buckley-Barrett ()
Date: March 29, 2010 03:28AM

Hi,

In my VB.NET application I have basically INSERT statements that have UTC_TIMESTAMP in them. For example

INSERT INTO Table! (DTSaved) VALUES (UTC_TIMESTAMP);

Between 1AM and 2AM on Sunday 28th March (when the clocks went forward for DST), I got 100s of the following errors.

INCORRECT DATETIME VALUE: '2010-03-28 01:59:53' FOR COLUMN 'DTSAVED' AT ROW 1

I tried repeating the error by adjusting my clock to the same time period but I didn't generate any errors. Has anyone come across this issue before? Would I be better off setting the DEFAULT value to UTC_TIMESTAMP for the field DTSaved and remove it from my INSERT statements?

Thanks for the advise,
Jim

Options: ReplyQuote


Subject Written By Posted
DST and UTC_TIMESTAMP Jim Buckley-Barrett 03/29/2010 03:28AM
Re: DST and UTC_TIMESTAMP Rick James 03/30/2010 08:42AM
Re: DST and UTC_TIMESTAMP Jim Buckley-Barrett 03/30/2010 08:53AM
Re: DST and UTC_TIMESTAMP Rick James 03/30/2010 10:26PM
Re: DST and UTC_TIMESTAMP Jim Buckley-Barrett 03/31/2010 01:51AM
Re: DST and UTC_TIMESTAMP Jim Buckley-Barrett 04/20/2010 09:33AM


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.