title: Oracle date calculations trunc(sysdate)
body: <p>I need to qualify a query from a  Database on Oracle for a report based on certain date ranges</p>
  
  <p>1st query</p>
  
  <p>5pm-7am  (Between 5pm yesterday  and Today 7am)</p>
  
  <p>2nd query</p>
  
  <p>for 7am-5pm ((Between 5pm yesterday , Today 7am)</p>
  
  <p>How would I do this??? I need to know Oracle Syntax to specify those date criterias</p>
  
  <p>Thanks in Advance</p>