Re: TIMESTAMPADD and Daylight Savings Time issue???
Peter, I read it differently.
* TIMESTAMP values are stored in UTC. There are no missing/extra hours in UTC. This storage format is identical to "Unix time", seconds of the 'epoch' from 1970-01-01 UTC.
* TIMESTAMP values are modified according the the timezone setting as they are stored and retrieved. Hence, you always see 'local' time, and there can be missing/extra hours in the display.
* DATETIME is stored in packed decimal (until sometime in 5.6); there is no conversion.
* A "properly" set up machine (timezone set to its location) on the other side of the world will see a different value than you do when SELECTing a TIMESTAMP, but will see exactly what you see when SELECTing a DATETIME (or DATE).
Subject
Written By
Posted
Re: TIMESTAMPADD and Daylight Savings Time issue???
May 04, 2012 08:40AM
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.