HI sonty,
Did U run that query after rectifying...
itt gives invalid number format model...
If i m wrong pls correct me.
Regards
Mayank
On Tue, Sep 8, 2009 at 4:31 PM, sonty <saurabh.zen...@gmail.com> wrote:
>
> 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 <mayank.del...@gmail.com> 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 <vladimir.mcbad...@gmail.com> 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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
