date format change
IshanMar 15 2012 — edited Mar 15 2012Hi,
Here goes the requirement.
Is there any way where we can convert incoming date in the format '31-DEC-99' to the format as '31-DEC-9999'?
if i use TO_DATE('31-DEC-9999', 'DD-MON-RRRR') it results in '31-DEC-1999'.
My question is how do I choose the format so that the Year part of the date goes to 9999 and not 1999?
Please advice.