title: How to extract millisecond from date in Oracle?
body: <p>i have full date(with time). 
  But i want only millisecond from date.</p>
  
  <p>please tell me one line solution</p>
  
  <p>for example: <code>date= 2016/03/16 10:45:04.252</code> 
  i want this answer= <code>252</code></p>
  
  <p>i try to use this query.</p>
  
  <pre><code>SELECT ADD_MONTHS(millisecond, -datepart('2016/03/16 10:45:04.252', millisecond),
       '2016/03/16 10:45:04.252') FROM DUAL;
  </code></pre>
  
  <p>but i'm not success.</p>