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

Home -> Community -> Usenet -> c.d.o.server -> Re: Format Number to Date

Re: Format Number to Date

From: Gernot Ficker <gernot_ficker_at_hotmail.com>
Date: Mon, 27 Jan 2003 19:06:45 +0100
Message-ID: <b13sf1$oe2$00$1@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 Mon Jan 27 2003 - 12:06:45 CST

Original text of this message

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