Does record response change during daylight savings

We are import date records from an old SQL DB to our main Oracle DB
10g as TIMESTAMP(0) WITH TIME ZONE.

The old SQL DB has a table that has records for when a server needs to
be autorebooted and the time zone. We have servers in EST, CST and
WST, but the SQL DB is in EST. So the old tool that does the reboot
looks at the TIMEZONE and REBOOT_DATE, to know the correct reboot
time.

SCECHULE_ID TIMEZONE REBOOT_DATE
179 0 10/22/2005 5:00
180 0 10/23/2005 5:00
181 3 10/24/2005 5:00
182 0 10/25/2005 5:00
183 1 10/26/2005 5:00
184 3 10/27/2005 5:00
185 0 10/28/2005 5:00
186 0 10/29/2005 5:00
187 1 10/30/2005 5:00
188 3 10/31/2005 5:00


I was able to import the 2.6 Million records with the correct time
zone, by altering my session for each TIMEZONE.

alter session set time_zone='-06:00'; for 1 = CST
Import all 1 TIMEZONE records
alter session set time_zone='-08:00'; for 3 = WST
Import all 3 TIMEZONE records
alter session set time_zone='-05:00'; for 0 = EST
Import all 0 TIMEZONE records

Our concern now is how will a record respond during daylight savings
is on.

So we import a REBOOT_DATE record as 3/17/2008 5:00:00 AM -05:00

During daylight will Oracle automatically respond with
3/17/2008 5:00:00 AM -04:00?

Or do I need to change all the REBOOT_DATE records during daylight
savings to -1 TIMEZONE? and if so how would that be done the easy way.

Thanks for all your help.

.

Relevant Pages

  • Re: Date problem
    ... even what a time zone is. ... time zone of the client, ... As far as I am aware, the browser does not notify the server what ... locale they are in, nor, specifically, what timezone. ...
    (comp.lang.php)
  • Re: optional timezones Re: (encode-universal-time) with fractional timezone offsets?
    ... Time zone values increase with motion to the ... the timezone: for example: ... (decode-universal-time utime NIL) is not portable ... think there is any cute solution for &optionals which suffer this ...
    (comp.lang.lisp)
  • Re: Breaking down Total Hours worked into Day and Evening hours
    ... electronic timesheets for purposes of comparing entered hours vs hours ... SQL, I'd like to explore those, as well. ... The time zone is a little more complicated, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Time zone problem moving from JDK 1.4 to 1.5
    ... > On HP-UX, we've always used 'MST7' for our timezone, and we've had no ... > Or was 'MST7' always wrong, and it just now decided to bite us? ... Take the following with a gain of salt, because time zone abbreviations ... specifications. ...
    (comp.lang.java.programmer)
  • Re: xsd:dateTime and sqltypes:datetime validations differ. Any idea why? Please help.
    ... I would stick with the XSD data types personally. ... If you wanted to store "date/time" type data without ... Another interesting feature of SQL 2005 xs:dateTime support is that all ... date/time values are converted and stored as UTC time (time zone Z). ...
    (microsoft.public.sqlserver.xml)