SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to identify when does the start and end dates Daylight saving.

KVBFeb 4 2013 — edited Feb 4 2013

Hi

I am using informatica.And I dont want to use manual mechanism in the middle of processing files.So what I thought is,if I can get the start and end date of Daylight Savings.So that I can load the dates in a separate table.Whenever the run starts,it will get the start and end dates using oracle database and load it into the table.

In the run,it can lookup the table to check the dates in the file lies between and end dates.

I know the standard dates of DST and Oracle automatically adjust them.
But if tomorrow the dates change for some X year.so that my run should not get affected.

I got a PLSQL functions which calculate the dates between standard dates.But what if the dates differ?

Can anyone please help me in this regard?

Regards
KVB

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2013

Added on Feb 4 2013

6 comments

1,284 views