9 lines
396 B
SQL
9 lines
396 B
SQL
select
|
|
sysdate - ( sysdate - date'1970-01-01' - &1/1000/86400 ) result_date
|
|
, round((( sysdate - &1 /1000/86400 ) - date'1970-01-01'),2 ) days
|
|
, round((( sysdate - &1 /1000/86400 ) - date'1970-01-01') * 24, 2 ) hours
|
|
, round((( sysdate - &1 /1000/86400 ) - date'1970-01-01') * 60 ) minutes
|
|
, round((( sysdate - &1 /1000/86400 ) - date'1970-01-01') * 3600 ) seconds
|
|
from dual;
|
|
|