Re: varchar to date
From: Brian Dick <bdick_at_home.com>
Date: Wed, 28 Nov 2001 02:20:40 GMT
Message-ID: <YRXM7.20063$Xb7.153186_at_news1.wwck1.ri.home.com>
Date: Wed, 28 Nov 2001 02:20:40 GMT
Message-ID: <YRXM7.20063$Xb7.153186_at_news1.wwck1.ri.home.com>
[Quoted] Don't cross-post. Many of us visit all of the Oracle newsgroups, and it's [Quoted] irritating to see the same question over and over and over.
"longinus" <longinus_at_zeus.polsl.gliwice.pl> wrote in message
news:3C040C2A.36EC3B0B_at_zeus.polsl.gliwice.pl...
> Date is stored in 'VARCHAR' field.
> SQL> select min(end_date)
>
> brings:
>
> MIN(END_DA
> ----------
> 15.10.2001
>
> I want to convert end_date (VARCHAR) for date and choose the oldest
> one..
> SQL> select min(to_date(end_date,'DD.MM.YYYY'))
> reached';
> ERROR:
> ORA-01839: date not valid for month specified
>
> What is wrong?????
Received on Wed Nov 28 2001 - 03:20:40 CET