title: Do I need to add anything more to the condition on this CASE WHEN statement?
body: <p>I'm new to SQL so I'm not sure if this will work. I would try it myself but currently I can't because I don't have access to the server the data is pulled from. The thing is when for example my third condition is true, the others are too. Do I have to add anything to the conditions to make the previous ones false or will it work and "ignore" the previous ones?</p>
  
  <pre><code>CASE WHEN
  TO_CHAR(f.time, 'dd.mm.yyyy HH24:mi:ss') &lt; TO_CHAR(SYSDATE, 'MM-DD-YYYY 
  HH24:MI:SS') 
  THEN ..... 
  WHEN TO_CHAR(f.time, 'dd.mm.yyyy HH24:mi:ss') + 2/24 &lt; TO_CHAR(SYSDATE, 'MM-
  DD-YYYY HH24:MI:SS') 
  THEN ..... 
  WHEN TO_CHAR(time, 'dd.mm.yyyy HH24:mi:ss') + 4/24 &lt; TO_CHAR(SYSDATE, 'MM-
  DD-YYYY HH24:MI:SS') 
  THEN .....  
  END bar
  </code></pre>
  
  <p>Don't mind what comes after THEN.</p>