RE: unix time conversion function

2003-01-24 Thread Post, Ethan
recipients of list ORACLE-LSubject: RE: unix time conversion function 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"

RE: unix time conversion function

2003-01-24 Thread Cary Millsap
Of Post, Ethan Sent: Friday, January 24, 2003 3:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: unix time conversion function   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 c

RE: unix time conversion function

2003-01-24 Thread Post, Ethan
Title: unix time conversion function 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 minu

RE: unix time conversion function

2003-01-24 Thread Adams, Matthew (GECP, MABG, 088130)
Title: RE: unix time conversion function Nevermind, Once I thought about it for more than 30 seconds, I got it. TO_DATE('01/01/1970','MM/DD/') + / 86400 easy as 3.141592654 Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, bu