var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to convert number of seconds(from January,1) in time format?
Do You have any idea?
Thanks a lot,Zvonimir
You could try this:
It, for :secs = 4539420, returns 22.02.2005. 12:57:00.
SELECT FLOOR(:secs/86400) +
TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, -TO_CHAR(SYSDATE, 'mm'))) + 1)
The second line (trunc ...) "sets" you to Jan 1st (this year), while 86400 represents number of seconds in one day.
-- This tells you the number of seconds from January 1, 2005 until now.
select (sysdate - trunc(to_date('01-JAN-2005', 'dd-MON-yyyy hh24:mi:ss')))*86400 from dual;
This tells you the timestamp that is N seconds after January 1, 2005. It prompts you for N.
select to_date('01-JAN-2005', 'dd-MON-yyyy hh24:mi:ss') + NUMTODSINTERVAL(&N, 'SECOND') from dual;
ooops, in the second example I meant to use TO_TIMESTAMP and not TO_DATE.