Re: Not a valid month error

"Karuna" <mrinalini.sukumar_at_gmail.com> wrote in message news:1112209818.353192.8700_at_f14g2000cwb.googlegroups.com...
>
> Sybrand Bakker wrote:
>> On 30 Mar 2005 10:40:26 -0800, "Karuna" <mrinalini.sukumar_at_gmail.com>
>> wrote:
>>
>> >When I try to do a select * from table; from sqlplus, the records
> are
>> >returned but at the end of the output, there's the error! - THE
> ERROR
>> >APPEARS AT THE END OF THE RESULTS.
>> >This particular table has NO date columns at all. Although it does
> have
>> >columns of char type that appear to hold date values.
>> >
>> >Can someone explain this error in this situation?
>>
>> *Exact statement*, table definition and output and error messages
>> please, also a version number should be included always.
>> I have *never* seen this in more than 15 years, so you are probably
>> doing something awfully wrong.
>>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
> Thanks for the reply.
> Here's the table definition.
> Table Name : Order
> which has the following definition.
> orderNo char(5)
> orderdate char(6).
>
> and the dates are inserted in the format "120190" etc where 12 is the
> month ad 01 is the day and 90 is the year. It has some records from 89
> and the rest from 90. And the query is:(I think I gave the wrong query
> the previous time)
>
> SELECT to_date(orderDate,'mm/dd/yy') from order;
>
> It shows all the records till 89. and it gives the error
> ORA 1843:not a valid month and stops the execution
> I actually am doing my assignment and the table is created my
> instructor and I have to use the table. I can't change the table
> definition. I am using UNIX and don't know sql*plus vesrion.
>

select to_date(orderDate,'mmddyy') from order; !!!!!!!!

gee whiz Received on Wed Mar 30 2005 - 13:25:00 CST