how can i store the date in this format: 12.03.2001?
Ron Reidy schrieb:
>
> longinus wrote:
> >
> > Becase the date type doesn't allow to store dates in 'DD.MM.YYYY'
> > format,e.g. '12.03.2001'.
> >
> > Damien Salvador schrieb:
> > >
> > > 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
> Wrong! Dates are **not** a VARCHAR type - they are numbers stored in
> the column. That is why the TO_DATE() function allows a picture clause
> - to format the output.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Tue Nov 27 2001 - 17:40:27 CST
