title: If actual date is Friday, also show rows at saturday and sunday Oracle DB
body: <p>Normally I only show a record, if the actual date is one year later than the date in the database. How can I check if that day is a friday and then show also the records with the date of the saturday or sunday?</p>
  
  <p>For example: Friday the 13th before one year. I will also show records from 14th(saturday) and 15th(sunday)</p>
  
  <pre><code>where myDate.arrival &lt; TRUNC (SYSDATE) -365)
  </code></pre>
  
  <p>That's my actual statement.</p>