Re: Not a valid month error

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 30 Mar 2005 07:02:40 -0800
Message-ID: <1112194960.105730.74750@o13g2000cwo.googlegroups.com>

Karuna wrote:
> I have a table with one of the columns as DDate(char(6) as the data
> type). I am trying to use to_date function in SELECT query to display
> all the records but it's giving "Not a valid month" for all the dates
> after the year 89. I tries to fix it with whatever infomration I
could
> get from the Interenet, but I am unable to correct the error.Any
ideas
> as to where the problem is?

At times like these... you wish you had thought about this at design time and stored dates in Date datatype.

Regards
/Rauf Received on Wed Mar 30 2005 - 09:02:40 CST