RE: unix time conversion function

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 24 Jan 2003 13:29:40 -0800
Message-ID: <F001.0053A135.20030124132940@fatcity.com>

Kinda...you can change the year to 1970 if you want, this also converts to minutes, not seconds. It is a really ugly function but it seems to work. You could always use perl.  

function f_minutes {

   # Funky function I use to calculate the number of minutes since 2000

   MIN_YEAR=$( date +"%Y" )
   MIN_YEAR=$( expr ${MIN_YEAR} - 2000 )
   MIN_YEAR=$( expr ${MIN_YEAR} \* 525600 )
   MIN_DAYS=$( date +"%j" )
   MIN_DAYS=$( expr "${MIN_DAYS}" - 1 )
   MIN_DAYS=$( expr "${MIN_DAYS}" \* 1440 )
   MIN_HOURS=$( date +"%H" )
   MIN_HOURS=$( expr "${MIN_HOURS}" \* 60 )
   MIN_MINS=$( date +"%M" )
   MIN_TOTAL=$(( ${MIN_YEAR} + ${MIN_DAYS} + ${MIN_HOURS} + ${MIN_MINS} ))

   print ${MIN_TOTAL}
}

-----Original Message-----
Sent: Friday, January 24, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L

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: Post, Ethan
  INET: Ethan.Post_at_ps.net

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 - 15:29:40 CST