CODEWITHSUNDEEP
mysql
user516883
user516883

Reputation: 9378

mysql get records greater than 10 hours

I have a time stamp in my table(2012-04-04 20:44:53) and i would like to select all of the records that are greater than 10.5 hours from the current time. Thanks for any help

Upvotes: 3

Views: 4402

Answers (1)

Marc B
Marc B

Reputation: 360702

SELECT ...
FROM ...
WHERE yourtimestampfield <= (NOW() - INTERVAL 10.5 HOUR)

Upvotes: 17

Related Questions