First, you can’t.
Sysdate doesn’t support going to milliseconds. However, starting with Oracle 9, you can getting milliseconds from another system source : SYSTIMESTAMP.
SELECT to_char(sysdate, 'HH24:MI:SS'), to_char(systimestamp, 'HH24:MI:SS.FF6') FROM dual;
Powered by Qumana
 | jasonvogel on Oracle and getting Millisecond… |
 | piyush on Oracle and getting Millisecond… |
 | celpjefscycle on Oracle SELECT with an array us… |
 | Idetrorce on Oracle SELECT with an array us… |
 | Phani Kumar on Oracle and getting Millisecond… |
Theme: Shocking Blue Green. Blog at WordPress.com.
