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. Received on Mon Oct 29 2007 - 10:27:25 CDT