SQL Oracle Query:
I have datetime values in 30 minute intervals. I want to stop each day at 2:30 PM.
I am limiting my hours with this:
TO_CHAR(ALL_DATES.DATEDATE,'HH24') NOT IN (01,02,03,04,05,06,07,17,18,19,20,21,22,23,00)
This gives me data from 8 AM to 3 PM. I need to only have data through 2:30.
Please show me how to do this better.
Advertisement
Answer
Plain Standard SQL, but Oracle chokes on DATEs.
TIMESTAMP datatype:
cast(ALL_DATES.DATEDATE as time) between time '08:00:00' and time '14:30:00'
DATE datatype:
cast(cast(ALL_DATES.DATEDATE as timestamp) as time) between time '08:00:00' and time '14:30:00'