Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Format Number to Date
I don't get it. What date is 24/01/72 ? Is it January 24th of the year 72?
and how does that = 26322? and even if the number in the field is 240172 are
you assuming that Oracle will just know that the 2 numbers in the middle are
months? If that were the case it would be something like
select to_date(substr(v.date_debut,3,2),'mm') from ...
or are you using Julian days? Rather sketchy on details. Numbers don't
equal dates unless there is some referent involved. (eg from a certain
date).
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Fred" <fpot_at_lucca.fr> wrote in message news:66412593.0301270758.51a88017_at_posting.google.com...Received on Mon Jan 27 2003 - 10:20:11 CST
> 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