SQL Select from table where timestamp is greater than 1 hours ago

Question

I have a column in my table called status_closed which is a datetime column

how can i run a query to select all rows where the status_closed is not within 24 hours

It is sad no one is marking this clear duplicate. – Jordan.J.D Jul 22 '14 at 13:56 — Jordan.J.D, Jul 22 '14 at 13:56

score 1 · Answer 1 · answered Jul 22 '14 at 13:53

1

Use TIMESTAMPDIFF() function of mysql.

select * from Table where TIMESTAMPDIFF(HOUR,status_closed,NOW())>24;

answered Jul 22 '14 at 13:53

Charvee Shah

score 1 · Answer 2 · answered Jul 22 '14 at 13:54

1

SELECT *
FROM `table`
WHERE status_closed < NOW() - INTERVAL 1 day

answered Jul 22 '14 at 13:54

George G

4

While this answer may solve the problem, you should elaborate on it a bit and explain what your code does. – David Rönnqvist Jul 22 '14 at 14:11
1

You're wrong, the code describes itself well – George G Jul 23 '14 at 08:39
Even if I find a correct code-only answer, I never upvote it because that only rewards/perpetuates the posting of more low-quality answers that care little about educating/empowering thousands of future researchers (who may or may not know a darn thing about the language that they are researching). – mickmackusa Jun 09 '20 at 22:36
1

Should be the accepted answer. Self-explaining code. – c0dehunter Feb 17 '21 at 21:44

score 0 · Answer 3 · edited May 23 '17 at 11:43

0

Subtracting a 1 day interval from NOW() will do the trick:

select 
  * 
from 
  table 
where 
  status_closed < NOW() - INTERVAL 1 DAY

edited May 23 '17 at 11:43

Community

answered Jul 22 '14 at 13:54

crthompson

score 0 · Answer 4 · answered Jul 22 '14 at 14:12

0

Use the DATEADD function, and check to see if the status_closed is less than or equal to 24 hours before now.

SELECT * FROM table
WHERE status_closed <= DATEADD(HOUR, -24, GETDATE())

answered Jul 22 '14 at 14:12

Steven

4 Answers4