I have a set of records that were created last week, and from those I want to retrieve only those that were created between 6h45 and 19h15. I have a column creation_date that I can use.

How can I do this in sql?

sql oracle-database date-arithmetic
Edit
Report