[RESOLVED] Comparing times

[AJArmstron]

Hi. In MySQL I have stored a timestamp as a field (called time) in a table.

I want to return a query to get rows in this table where the timestamp is say greater than five hours old.

I would be grateful if anyone could help?

[Lars_Berg]

where `time` < current_timestamp - interval '5' hour

[AJArmstron]

Yes - thank you. I used the below code.

select * from carttotal where time < now()-interval 5 hour;