Getting Milliseconds from Oracle Timestamps
3 (extract (minute from tim_col2)-extract (minute from tim_col1))*60+. 4* extract (second from tim_col2)-extract (second from tim_col1))*1000 ms from check_time. 5 /. MS. ---------. 97094. Well, that is more like it! So now we can get the milliseconds between and do the aggregation functions such as sum () and avg () on the results. Question ...