Hi z1hou1
Hope This will Be the Solution for ur desired Result.
If i am wrong Pls correct me.
SELECT DECODE (TO_CHAR (TO_DATE ('0101' ||:yr, 'ddmmyy'), 'day'),
'sunday', TO_DATE ('0101' ||:yr, 'ddmmyy'),
NEXT_DAY (TO_DATE ('0101' ||:yr, 'ddmmyy'), 'sunday')
)
FROM DUAL;
Regards
Mayank
On Tue, Sep 8, 2009 at 4:57 PM, z1hou1 <[email protected]> wrote:
>
> Hi Mayank,
> Your solution is the simplest, but there is an issue with 2006. For
> 2006, 1-jan-2006 falls on a Sunday. So, if we are looking a Sunday
> AFTER the 1st of the year, your solution is without doubt the easiest.
>
> z1hou1
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
