Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> plsql / function / convert to date
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:20:35 CST