Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: unix time conversion function

RE: unix time conversion function

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 24 Jan 2003 15:33:54 -0800
Message-ID: <F001.0053A3BA.20030124153354@fatcity.com>


Yes I knew it was easier in perl, I prefer to distribute a single script whenever possible and I write pretty much everything in shell. However, I just figured out a trick to put the perl directly in my .ksh scripts (see the post I posted a few minutes ago) so I will likely change the way I have been doing that. Thanks for the perl however, saved me some time looking it up!  

See ya at the Symposium!  

Thanks,
Ethan

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

At the risk of stating the obvious, doing it in Perl looks like this:  

#!/usr/bin/perl

use Date::Format qw(time2str);

my $t = 1043447100; # for example

print time2str("%T %A %d %B %Y", $t), "\n";  

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com <http://www.hotsos.com>

Upcoming events:
- 2003 Hotsos <http://www.hotsos.com/events/symposium> Symposium on OracleŽ
System Performance, Feb 9-12 Dallas
- RMOUG Training Days 2003 <http://www.rmoug.org> , Mar 5-6 Denver

-- 
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 - 17:33:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US