DateTime condition

Asked May 28 '19 at 12:38

Active May 28 '19 at 13:03

Viewed 38 times

I'm trying to make a condition I want to select only the lines where the date field is 2h before at least but I can't find how to make this where clause.

The current date is:

2019-05-28 14:30:00

I have in database those line

2019-05-28 13:30:00

2019-05-28 10:30:00

I want to be able to catch the second one.

I could get all result one by one...turning them into timestamp...but I feel like I can do this in a simple sql request.

I was thinking about BETWEEN, but I don't see how it will worked in this case.

Thanks.

Issue solved:

If someone can post it as a response: We need a combinaison og DATE SUB and INTERVAL

SELECT * FROM `offer` WHERE updatedAt < DATE_SUB(NOW(), INTERVAL 2 HOUR);

edited Jun 20 '20 at 09:12

Community

asked May 28 '19 at 12:38

Minirock

3

_where the date field is 2h before_ 2 hours before what? – RiggsFolly May 28 '19 at 12:39
2

Does you column REALLY contain `2019-28-05 14:30:00` i.e. `YYYY-DD-MM HH:MM:SS` because that is NOT a valid `DATE` or `DATETIME` column which is going to make ANY date or time querying Vastly more complex for you to code. **PS** Dont use VARCHAR to store Dates and Times!# – RiggsFolly May 28 '19 at 12:40
you can check on mysql intervals. http://www.mysqltutorial.org/mysql-interval/ – ns15 May 28 '19 at 12:43
My mistake. It's a valid DateTime 05-28 and not 28-05 – Minirock May 28 '19 at 12:43
`SELECT * FROM your_tabl WHERE dt < NOW() - INTERVAL 2 HOUR` ? – Oto Shavadze May 28 '19 at 12:51
@OtoShavadze When I try this `SELECT * FROM app__offer WHERE updatedAt < NOW() - INTERVAL 2 HOUR` ---> It says the key work INTERVAL and HOUR is unknown – Minirock May 28 '19 at 12:54
@Minirock - Strange, it works for me – Oto Shavadze May 28 '19 at 13:02

DateTime condition

0 Answers0