title: how to get date part in oracle
body: <pre><code>id  name date
  1   AAA 12-01-15
  2   BBB 19-09-12
  3   CCC 23-07-10
  4   DDD 06-10-01
  5   EEE 08-11-05
  6   FFF 18-04-99
  7   GGG 07-08-12
  </code></pre>
  
  <p>i have  tried it but by converting it is possible but i dont want to convert it  i want to extract only date part help me out please </p>
  
  <p>i have a table with date field with datatype  i want to extract date from date field</p>
  
  <p>my condition is i want to get records which equal to sysdate i.e i want to get records which are inserted on present day which equal to datepart</p>