Query return data between two fixed points in time.

[gandolf989]

What about this?

SELECT xxxx.table
  FROM table
 WHERE to_date(reportdate,'DD/MM/YYYY')
       BETWEEN TRUNC(sysdate) - 7 + 6/24
           AND to_date(reportdate,'DD/MM/YYYY') + 6/24;