title: Convert datetime field to just a date field in SQL (Oracle)
body: <p>I've seen a few answers to questions similar to mine but I cannot get them to work. I have several date fields in my query that return the date and time like such 7/1/2014 12:00:00 AM. Is there a way I can just have the fields show 7/1/2014?</p>
  
  <pre><code>SELECT DISTINCT
  C.RECEIPTDATE,
  (I.CLIENTID ||' - '||PO.CLIENTNAME) AS CLIENT,
  D.INVOICEID,
  D.SVCFROMDATE,
  D.SVCTODATE,
  D.SVCCODE
  FROM M_EQP_ORDERS
  WHERE.....
  </code></pre>
  
  <p>I basically would like to cut down the two date fields to the shorter date format minus the time.</p>
  
  <p>Thanks in advance!</p>