RE: Converting a Number to a Date

Try using something like

select to_date ('1/1/1970','DD/MM/RRRR') + (create_date/86400) from table_name;

where create_date is a column that has the unix type date in it.

hth,

bhadresh patel
oracle dba
reston, va

> -----Original Message-----
> From: David Barbour [SMTP:DBarbour_at_connectsouth.com]
> Sent: Wednesday, June 14, 2000 4:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Converting a Number to a Date
>
> I have what appears to be a UNIX-style timestamp series of numbers which I
> have to convert back to dates.
>
> They're in the format 960770731
>
> I've tried a number of things, but haven't figured it out yet. Has
> anybody
> encountered something similar?
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
> --
> Author: David Barbour
> INET: DBarbour_at_connectsouth.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 14 2000 - 16:47:16 CDT