Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DAte conversion

Re: DAte conversion

From: longinus <longinus_at_zeus.polsl.gliwice.pl>
Date: Wed, 28 Nov 2001 00:06:37 +0100
Message-ID: <3C041C7D.E75B9236@zeus.polsl.gliwice.pl>


SQL> select min(to_date(end_date,'D.M.YYYY')) ached';
ERROR:
ORA-01821: date format not recognized

Jim Kennedy schrieb:
>
> It could also be that it is a date like 06.1.2000 and that won't work
> either.
> try 'D.M.YYYY' that might work.
> Damien is correct store dates in date fields.
> Jim
> "Damien Salvador" <damien.salvador_at_via.ecp.fr> wrote in message
> news:slrna08461.t6e.damien.salvador_at_zen.via.ecp.fr...
> > On Tue, 27 Nov 2001 22:56:08 +0100, longinus
> > <longinus_at_zeus.polsl.gliwice.pl> a écrit:
> > >Date is stored in 'VARCHAR' field.
> >
> > >
> > >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?????
> >
> > Are you sure ALL your dates are in the DD.MM.YYYY form ?
> > Isn't there a MM.DD.YYYY date ? Maybe there is an invalid
> > date in your column.
> >
> > Why don't you store your dates in a date column ?
> >
> >
> > --
> > Damien
> >
Received on Tue Nov 27 2001 - 17:06:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US