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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
