Looks like we may want to add trim to make 2006 work correctly:
SQL>SELECT DECODE (trim(TO_CHAR (TO_DATE ('0101' ||&&yr, 'ddmmrr'),
'day')), 'sunday',
2 TO_DATE ('0101' ||&&yr, 'ddmmrr'),
3 NEXT_DAY (TO_DATE ('0101' ||&&yr, 'ddmmrr'),
'sunday')
4 )
5 FROM DUAL;
Enter value for yr: 06
old 1: SELECT DECODE (trim(TO_CHAR (TO_DATE ('0101' ||&&yr,
'ddmmrr'), 'day')), 'sunday',
new 1: SELECT DECODE (trim(TO_CHAR (TO_DATE ('0101' ||06, 'ddmmrr'),
'day')), 'sunday',
old 2: TO_DATE ('0101' ||&&yr, 'ddmmrr'),
new 2: TO_DATE ('0101' ||06, 'ddmmrr'),
old 3: NEXT_DAY (TO_DATE ('0101' ||&&yr, 'ddmmrr'),
'sunday')
new 3: NEXT_DAY (TO_DATE ('0101' ||06, 'ddmmrr'),
'sunday')
DECODE(TRIM(TO_CHAR
-------------------
2006-01-01 00:00:00
- Denis
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
