Home » SQL & PL/SQL » SQL & PL/SQL » How to convert a number to date?
How to convert a number to date? [message #36092] Mon, 05 November 2001 01:25 Go to next message
Nicola Farina
Messages: 63
Registered: October 2001
Hi all,

I am doing a little "reverse-engineering" of a Oracle table.
I know that in a field of this table it is stored a date-time pair, but the field is a number type. The values are of this kind:
36669,6295717604 and so on..
Is there any chance, in your opinion, that this format would be the same used internally by Oracle for DATE columns?
Which is the best/quick way to convert this value in a date via SQL?
I tried
select ...TO_DATE(FieldNumber) but obviously this doesn't work..
Thanks in advance for any help!

Re: How to convert a number to date? [message #36093 is a reply to message #36092] Mon, 05 November 2001 01:30 Go to previous message
Messages: 17
Registered: October 2001
Junior Member
I believe but not sure.
Try it

Previous Topic: Define or Accept
Next Topic: Re: How to convert a number to date?
Goto Forum:

Current Time: Thu May 23 01:14:52 CDT 2024