dates!= numbers. I don't know what 37679 is. Is it the number of days
since some particular date? If it is and it turns out to be the number of
days since 1/1/1970 then do
update mytable set mydate_col=(to_date('1/1/1970','m/d/yyyy')+
my_number_col);
You are going to have to figure out what this MS number means in relation to
dates; it doesn't meet any standard that I know of.
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.
"Oliver Demus" <oliver_at_demus-online.de> wrote in message
news:62e59750.0302261920.13223791_at_posting.google.com...
> Hi there,
> we save in our database the date as a number e. g. 27. Feb 2003 =
> 37679.
> I donīt know the reason for that. But I have no idea, how to convert
> it back to a date in Oracle plsql. In VB you can do it with
> cdat(37679).
> Is there any possibility in Oracle?
>
> Thanks in advance
> Oliver
Received on Wed Feb 26 2003 - 21:51:59 CST
