difference in milliseconds between starttimestamp and endtimestamp
565797Feb 15 2013 — edited Feb 19 2013I'm having this issue....
I have 2 columns starttimestamp and endtimestamp and both have 13:45:57 on their time...
I would like to know the milliseconds of difference between them..How can achieve that....
select (ENDTIMESTAMP-STARTTIMESTAMP) as tempo_execucao
from eil_adapter_log_view
WHERE TO_DATE ('13-02-2013 13:30:00', 'dd-mm-yyyy hh24:mi:ss') < starttimestamp
AND TO_DATE ('11-02-2013 14:30:00', 'dd-mm-yyyy hh24:mi:ss') > starttimestamp
and interfacename = 'Inbound/GetPortfolio.process'
order by starttimestamp desc;
Can anyone help?
Best Regards,
Rui Oliveira