How to show last 10 min old records from mysql

Question

I have a MySQL database having column time containing Unix timestamp like 1482858013.

Now I want to make a MySQL query which should show only the last five minute old records from the database. How can I do this? Thanks in advance.

Answer 1

Use DATE_SUB() to get the time 5 minutes ago, and UNIX_TIMSTAMP() to convert that to a numeric timestamp.

WHERE time > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 5 MINUTE))

Answer 2

SELECT FROM_UNIXTIME(timestamp/1000,'%Y-%M-%d) as timestamp FROM table
    WHERE timestamp > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 10 MINUTE))
    Order by timestamp desc

Answer 3

Assuming that your table is called ata_table, then query would be something like:

select
  *
from data_table
where
    `time` > unix_timestamp()-300;