Hello,

I have a MySQL timestamp column in my table, problem is, i want to see if any are older than 24 hours, how would i be able to do that with the MySQL timestamp?

Thanks.

SELECT fields FROM table WHERE ts_field >= ts_field+(60*60*24)

__________________

Unless I'm mistaken, or have mistyped something, I'm sure this is what you're after. The timestamps are stored in seconds, though not a strictly integer format mind you, so convert to seconds and compare the difference. This won't work for times in the future versus the current time though, as they'll always turn out to be negative.

__________________
Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning. - Rich Cook

There are a whole bunch of functions available in MySQL to play around with dates: MySQL Date & Time Functions

Yeah, I was digging in my MySQL reference book, since Srev got me interested, and I think this would be a better method:
That makes it a whole lot simpler than what I thought of before. However it does require MySQL 5.0 and upwards.

__________________
Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning. - Rich Cook

You could also play around with DATE_ADD/SUB, for example:
SELECT DATE_SUB(NOW(), INTERVAL 24 HOUR) AS 24_hours_ago;

Hmm... oddly enough none of them seemed to of worked :s
I have MySQL5+ too

When you say none worked, could you provide us with some details; exact queries used, your exact MySQL version, copy/paste error messages, etc?

Well Salathe, yours thinks every date is older than 24 hours :s, any ideas?

What query are you using?

SELECT *
FROM `my_rss_feeds`
WHERE DATE_SUB( NOW( ) , INTERVAL 24 HOUR )
LIMIT 0 , 30

After a quick chat on IRC, we settled on using:
DATE_SUB(NOW(), INTERVAL 24 HOUR) > rsstimestamp
(where rsstimestamp is the TIMESTAMP column). :)