title: sql oracle case when date
body: <p>This is what I got so far:</p>
  
  <pre><code>select
  to_char(sysdate, 'yyyy') Time
  from 
  dual;
  </code></pre>
  
  <p>Which gives me:</p>
  
  <pre><code>TIME
  
  2015
  </code></pre>
  
  <p>Its working until this point.</p>
  
  <p>I would like to add </p>
  
  <ul>
  <li>if the month is <code>&gt;= 7</code> I get as output <code>01.07.current year</code></li>
  <li>if the month is <code>&lt;= 7</code> I get as output <code>01.07.(current year - 1 year)</code></li>
  </ul>
  
  <p>Any ideas how to handle this? I thought about CASE WHEN but I dont get know how.</p>
  
  <p>Thanks!</p>