Check where you are running from I ran from Toad
On Sep 8, 4:12 pm, Mayank kashyap <[email protected]> wrote:
> 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 <[email protected]> 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 <[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 -- 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
-~----------~----~----~----~------~----~------~--~---
