Oracle equaivalent of java System.currentTimeMillis()?
- by Gaurav
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?