Re: date format in epoch

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Wed, 24 May 2006 15:49:40 -0700
Message-Id: <1148510980.6161.262260486@webmail.messagingengine.com>

Bounced due to Quota exceeding. Reposting.

  SQL>create or replace function cdate ( i_date IN NUMBER) RETURN DATE IS     2 l_date date;
    3 begin

    4          l_date := to_date('01/01/1970','MM/DD/YYYY')
    5                + ((i_date)/(60*60*24)) + (to_number(rtrim(sessiontimezone, ':00'))/24);

    6 return l_date;
    7 exception when others then
    8 null;
    9 end;
   10 /

  Function created.

  SQL>select (SYSDATE - TO_DATE('01011970000000' , 'ddmmyyyyhh24miss')) * 86400 AS epoch_date FROM dual     2 /

  EPOCH_DATE

---

  1148397334

  1 row selected.

  SQL>SELECT TO_CHAR(cdate(&elapsed_secs),'dd-mon-yyyy hh24:mi:ss') current_time from dual     2 /
  Enter value for elapsed_secs: 1148397334   old 1: SELECT TO_CHAR(cdate(&elapsed_secs),'dd-mon-yyyy hh24:mi:ss') current_time from dual   new 1: SELECT TO_CHAR(cdate(1148397334),'dd-mon-yyyy hh24:mi:ss') current_time from dual

  CURRENT_TIME

---

  23-may-2006 08:15:34

  1 row selected.

  SQL>   HTH   GovindanK

  On Tue, 23 May 2006 13:08:12 -0700, [1]"Anthony Ettinger" <aettinger_at_sdsualumni.org> said:     I have a timestamp in seconds since the epoch, how do I get it back     into a human-readable date? ie - to_date('$secs_since_epoch',     'yyyymmdd') ?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 24 2006 - 17:49:40 CDT