title: TIMESTAMP To DATE in Oracle SQL
body: <p>I have a column called Create_Date which has data in the format like <code>19-JUN-18 10.27.00.000000000 PM</code> and data type is <code>TIMESTAMP(6)</code>.</p>
  
  <p>I am trying to look at date range like yesterday's date or between two dates in Create_Date without using <code>TO_DATE(TO_CHAR(P.CREATE_DATE_TIME,'dd/mon/yy'))</code> and entering the value as <code>'19-JUN-18'</code>.</p>
  
  <p>I want to use <code>Create_Date=SYSDATE-1</code> OR <code>Create_Date=CURRENT_DATE-1</code> instead to filter on yesterdays date. Or Use <code>Create_Date&gt;=SYSDATE</code> or <code>Create_Date&gt;=CURRENT_DATE</code> to look at dates greater than or equal to today.</p>
  
  <p>Can someone help?</p>