title: How can I get sysdate formatted as YYYY/MM/DD and still be a date?
body: <p>When I run this code: </p>
  
  <pre><code>select trunc(TO_DATE(sysdate,'YYYY/MM/DD'),'Day')-43 from dual
  </code></pre>
  
  <p>Oracle returns: </p>
  
  <pre><code>28/06/0027
  </code></pre>
  
  <p>I am using <code>'Day'</code> for the trunc argument because I want go back 43 days from the beginning of the week. I need the data format to be 2015/07/11, and the data to be typed as a date, not char or anything else. I need this because I am using the date to filter on a table with a date column in the YYYY/MM/DD format. </p>
  
  <p>How can I get the above SQL to give out YYYY/MM/DD typed as a date?</p>