Re: plsql / function / convert to date

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 27 Feb 2003 08:20:57 +0100
Message-ID: <1046330439.611007@news.thyssen.com>

"Oliver Demus" <oliver_at_demus-online.de> schrieb im Newsbeitrag 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

Hi Oliver,

off topic (german): Mann, Frühaufsteher?

on topic:
a little test (select sysdate - 37679 from dual) showed 30.12.1899 (dd.mm.yyyy) as result. So it seems that this app uses the last day of the 19th century as the basis. If I'm right with this, you can proceed with the advice offered by Jim.

Hth and Grüße,
Guido Received on Thu Feb 27 2003 - 01:20:57 CST