RE: Converting a Number to a Date

David

   this is just a guess that it might be the number of seconds since January 1, 1970 (time zero for unix) and this number equates to about 30 years, which is about how much time has elapsed since 1970.

just a guess

Mary Ruiz
Atlanta

> -----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 - 14:33:16 CDT