This content has been marked as final. Show 6 replies
Check your NVL. You state nvl(MDATE_FROM,' ') which means if MDATE_FROM is Null, then return ' '. Then you try to TO_CHAR(<date>, 'YYYYMMDD') which couldn't possible work for date ' '.
But pal i want to put null 8 charcters if mdate is null how can i do it?
I was hoping that you'd look at your code for a couple of minutes...
Well, you have to put the NVL first instead of in the TO_CHAR statement.
Martin is trying to get you to do some of the work yourself. But I'll just give you the answer:
Or better yet, use this
Yaa Steve you are rightooo (Y) Yo Da Man..
Dun Jealous Others lolz ;) kiddin
Thanx to allz i got it..