Oracle equaivalent of java System.currentTimeMillis()?

Posted by Gaurav on Stack Overflow See other posts from Stack Overflow or by Gaurav
Published on 2010-05-13T06:07:18Z Indexed on 2010/05/13 6:14 UTC
Read the original article Hit count: 200

Filed under:

Hi,

I want to be able to store the current time in millis in an oracle number field. How do I do this via a query?

select systimestamp from dual; returns the actual timestamp. Is there anyway that I can convert this into milliseconds the same way java's System.currentTimeMillis() does?

© Stack Overflow or respective owner

Related posts about Oracle