title: Trunc function a specfic column in SQL
body: <p>I am new with SQL and I am trying to run the below statement but its obviously not working. I need to truncate the "creat_DTTM" it has the date and time in it and I need to remove the time, so I can query off of the column. Any help is greatly appreciated.</p>
  
  <pre><code>Select *
    From icue.cmnct_trans
       WHERE Trunc(creat_DTTM) between ('19-feb-2018') AND  ('06-MAR-2018')
        AND  FAX_NBR = '201-553-7889'
        AND  RPT_PROV_NM ='CHILDRENS HOSP PHILADELPHIA'
  </code></pre>