V
V
Vladimir2017-07-04 12:14:01
MySQL
Vladimir, 2017-07-04 12:14:01

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

1 answer(s)
T
terrier, 2017-07-04
@dromenkojunior

So after all to select all records which
1). After the start of the week
2). Extract the time from the timestamp, it should be later than 19:30,
shouldn't it?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question