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 18:47:31 +0100
Message-ID: <3C052333.1859EAB8@zeus.polsl.gliwice.pl>


It looks ok, but what if I want to display the month as a number according to the format i wrote?

Andy schrieb:
>
> On Wed, 28 Nov 2001 00:40:27 +0100, longinus
> <longinus_at_zeus.polsl.gliwice.pl> wrote:
>
> >how can i store the date in this format: 12.03.2001?
> >
>
> create table testtable(f_datefield date);
>
> insert into testtable(f_datefield)
> values (to_date('01.01.2001','DD.MM.YYYY');
>
> commit;
> select to_char(f_datefield,'DD-MON-YYYY') foo from testtable;
>
> foo
> ------------------
> 01-JAN-2001
>
> hth
> Andy
>
> >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 =E9crit:
> >> > > >Date is stored in 'VARCHAR' field.
> >> > >
> >> > > >
> >> > > >I want to convert end_date (VARCHAR) for date and choose the oldes=
> >t
> >> > > >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 Wed Nov 28 2001 - 11:47:31 CST

Original text of this message

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