RE: unix time conversion function

From: Adams, Matthew (GECP, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 24 Jan 2003 11:39:26 -0800
Message-ID: <F001.00539FDB.20030124113926@fatcity.com>

Nevermind,

Once I thought about it for more than 30 seconds, I got it.

TO_DATE('01/01/1970','MM/DD/YYYY') + <SECONDS> / 86400

easy as 3.141592654

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won
when it came to kick boxing.

-----Original Message-----
Sent: Friday, January 24, 2003 2:12 PM
To: 'oracle-l_at_fatcity.com'

Anybody got a handy little function to
convert a standard unix seconds-since-Jan-1970 epoch time (stored as a number) to a readable date?

It would save me a lot of time not having to re-invent the wheel.

Matt

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won
when it came to kick boxing.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Adams, Matthew (GECP, MABG, 088130)   INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Fri Jan 24 2003 - 13:39:26 CST