Re: Format Number to Date

Wow - talk about the blind leading the blind!

Using "TO_DATE()" without a format string is asking for big problems, especially as the default string is "DD-MON-YY"!

Implicit type conversions (of which you are doing one and a half here - adding dates and numbers is dodgy too) caused about 98% of the Y2K problems I encountered and fixed. They also slow down program execution as the conversion method is decided on at run time not compile time.

-

ETA "Gernot Ficker" <gernot_ficker_at_hotmail.com> wrote in message news:<b13sf1$oe2$00$1_at_news.t-online.com>...
> select to_date('30.12.1899') + 26322
> from dual
>
> "Fred" <fpot_at_lucca.fr> schrieb im Newsbeitrag
> news:66412593.0301270758.51a88017_at_posting.google.com...
> > Hello,
> >
> > The date are in field NUMBER(6), example : 24/01/72 = 26322
> > The problem is in this requete :
> >
> > SELECT TO_DATE(V.date_debut, 'MM') FROM ***
> >
> > The date in number must be in format date but the function TO_DATE isn't
> correct.
> >
> > Do you have a solution ?
> >
> > Thank you
Received on Wed Feb 05 2003 - 04:07:31 CST