Re: Not a valid month error

> I am using UNIX and don't know sql*plus vesrion.

It ought to tell you the version when you log on to sqlplus.

What happens when you do not convert the date at all? Try comparing that with what you get when you get the error. I would guess the next row in the unconverted list after the last one in the converted list would have an obvious problem. If it is still not obvious try using the substr function to split out the data. spool it to a file and disect with od -c.

See http://www.dbaoracle.net/readme-cdos.htm about posting here.

jg

--
@home.com is bogus.
http://www.wired.com/wired/archive/13.04/robot.html