select records that are less than 2 hour

[Anon]

Hi,

I have reconds in the mysql database that are constantly being added. One of fields is a TIMESTAMP, so what I would like to do is just select secords that are less than two hours old.

Can anybody help me out?

Thanks,

Andy

[Anon]

Just figured that out yesterday:

SELECT * FROM some_table
WHERE UNIX_TIMESTAMP(NOW()) > (UNIX_TIMESTAMP(timestamp_field) + 7200)

The 7200 is the number seconds in two hours.
One hour has 3600 seconds, so whatever amount of hours you want to check for, just multiply it by 3600.

cheers,
DrTebi