Epoch
Friday, June 27th, 2008How do I get the current number of milliseconds since 1970-01-01.
I still have no access to oracle.com so I created a new account to answer this question.
Either you use the difference between timestamp ‘1970-01-01 00:00:00 +00:00′ and current_timestamp, or you can use java, which is more portable.
YMMV
create function epoch return number as language java name
'java.lang.System.currentTimeMillis() return int';
/
select epoch from dual;
EPOCH
----------------
1214562599878
