Answer the question
In order to leave comments, you need to log in
How to select all records for a week after a specific time?
There is a task to select for the week all the actions that were after 19.30 every day .
How to do it right? Add an interval to a date? Or select everything, and then cut off the unnecessary by grouping?
select * from table
WHERE created >= '2017-06-26 19:30:00'::timestamp + '1 day'::interval
and date_create < '2017-06-30'
but the query will not work correctly. How is it necessary?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question