CODEWITHSUNDEEP
mysqldatetime
hakki
hakki

Reputation: 6501

MYSQL date subtraction

I want to substract date to reach online users where have been in 10 minutes. My logic is like below. But it is not working

SELECT * FROM user WHERE NOW() - user_last_login <=10

is it good approach?

I store date in format : 2013-09-05 15:30:45 -- YYYY-MM-DD HH:MM:SS

Upvotes: 0

Views: 1015

Answers (2)

Naveen Kumar Alone
Naveen Kumar Alone

Reputation: 7668

You can use MySQL TIMESTAMPDIFF() function to find it

SELECT * FROM user WHERE TIMESTAMPDIFF(MINUTE,NOW(),user_last_login)<=10

Upvotes: 1

juergen d
juergen d

Reputation: 204746

SELECT * FROM user 
WHERE NOW() - interval 10 minute <= user_last_login

Upvotes: 2

Related Questions