MySQL Forums
Forum List  »  General

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
March 29, 2010 03:28AM
March 30, 2010 08:42AM
March 30, 2010 10:26PM


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.