Re: DAte conversion

From: Andy <as.no.spam.stedat_at_gmx.net>
Date: Wed, 28 Nov 2001 11:55:12 GMT
Message-ID: <3c04cff4.19505467@by-news.bayer-ag.com>

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 - 05:55:12 CST