DST and UTC_TIMESTAMP
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
Subject
Written By
Posted
DST and UTC_TIMESTAMP
March 29, 2010 03:28AM
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.