Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql compare timestamp in minutes

select from_unixtime(`your_timestamp`) as lastdt from `sessions` 
WHERE from_unixtime(`your_timestamp`) >= NOW() - INTERVAL 15 MINUTE
ORDER BY your_timestamp DESC;
 
PREVIOUS NEXT
Tagged: #mysql #compare #timestamp #minutes
ADD COMMENT
Topic
Name
6+1 =