Re: date format in epoch
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: aettinger@xxxxxxxxxxxxxx, cjpengel.dbalert@xxxxxxxxx
- Date: Wed, 24 May 2006 15:49:40 -0700
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@xxxxxxxxxxxxxx> 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') ?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
