Topic: Data from a temporal interval.
All greetings. The help is urgently necessary. I need to return statistics for the last 7 days and that records created would be returned from 8:00 till. CREATED is a date creations, such type of 10/26/2017 of 7:53:17 PM. The conditions resulted more low yield empty result. Prompt please, in what an error or other variants.
In advance thanks.
AND created> sysdate - 7
AND created BETWEEN to_date (' 8:00:00 AM ', ' HH24:MI:SS') AND to_date (' 6:00:00 PM ', ' HH24:MI:SS')