Re: Not a valid month error

Karuna (mrinalini.sukumar_at_gmail.com) wrote:

: Dave wrote:
: > "Karuna" <mrinalini.sukumar_at_gmail.com> wrote in message
: > news:1112209818.353192.8700_at_f14g2000cwb.googlegroups.com...
: > >
: this error in this situation?
: > >>
: > select to_date(orderDate,'mmddyy') from order; !!!!!!!!
: >
: > gee whiz

: Well I had tried that as well and it's not working

It is working, it just isn't doing what you want.

You are asking the database to convert various strings into dates and the database is telling you that at least one of the strings you wish to convert cannot be converted because the string has characters in it that do not represent a valid month.

A string such as 'bogus!' would cause this error, as would less obvious examples such as '130190' (which would be the 1st day of the 13th month of 1990), or 1OO29O (note the oh's instead of zeroes).

--

This space not for rent.