just rectifying Mayank's Answer:
Select Next_day(To_date('0101'||to_char
(:P_DATE,'YY'),'ddmmyy'),'sunday') "First Sunday" from dual;
Regards,
Sonty
On Sep 8, 9:48 am, Mayank <[email protected]> wrote:
> Hope this query will help you.
>
> Select Next_day(To_date('0101'||:yr,'ddmmyy'),'sunday') from dual;
>
> Regards
> Mayank
>
> On Sep 7, 3:16 pm, Vlad <[email protected]> wrote:
>
>
>
> > I want to be able to calculate the first sunday for a given year:-
>
> > E.g. given a date 1/7/2009 - I want the result to return the date of
> > the first sunday in 2009. (i.e. 4/1/2009).
>
> > Is there a simple way to do this?
>
> > TIA- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
