Hi Gurus
I have one date column and I'm trying to put nvl in case date is null so I think first I need to convert it into to_date and then need to apply nvl. Rite?
like this:
I think my my database NLS date format is 'DD-MON-YYYY' or DD-MON-RRRR ' because when I issue this command select sysdate from dual then it shows date in this fomat.
----------------------------
The problem is that when I issue select to_date( start_date,'DD-MON-YYYY') from dual; command then I receive the following error message:
full year must be between -4713 and so on ..........................
...............
but when I changed it to select to_date( start_date,'DD-MON-RRRR') from dual; then its working fine.
My question is that can I use use RRRR instead of YYYY and then convert it into by using nvl or omit to_date and directly convert it into my desired date format like below:
nvl(start_date,'31-DEC-4444'). Please guide
Regards
Shu