Re: Aruneesh Salhotra

Aruneesh Salhotra wrote:

> I created a oracle query which detects the start and end date for
> dayight saving. I eventually used this, and passed the current year so
> to detect start/end dates for daylight saving for each year.
>
> I wanted to share the same with everyone.
>
> select SYSDATE x, 0 r1 from dual where SYSDATE between (select
> decode(to_char(to_date('04/01/2003','MM/DD/YYYY'),'D'),1,
> to_date('04/01/2003','MM/DD/YYYY')+7, 2,
> to_date('04/01/2003','MM/DD/YYYY')+6, 3,
> to_date('04/01/2003','MM/DD/YYYY')+5, 4,
> to_date('04/01/2003','MM/DD/YYYY')+4, 5,
> to_date('04/01/2003','MM/DD/YYYY')+3, 6,
> to_date('04/01/2003','MM/DD/YYYY')+2,
> to_date('04/01/2003','MM/DD/YYYY')) sday1 from dual) and (select
> decode(to_char(to_date('09/01/2003','MM/DD/YYYY'),'D'),1,
> to_date('09/01/2003','MM/DD/YYYY')+7, 2,
> to_date('09/01/2003','MM/DD/YYYY')+6, 3,
> to_date('09/01/2003','MM/DD/YYYY')+5, 4,
> to_date('09/01/2003','MM/DD/YYYY')+4, 5,
> to_date('09/01/2003','MM/DD/YYYY')+3, 6,
> to_date('09/01/2003','MM/DD/YYYY')+2,
> to_date('09/01/2003','MM/DD/YYYY')) sday2 from dual);

Nice.

But unfortunately some places do not observe daylight savings time. Among them several entire states.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)