[RESOLVED] Deleting records that are an hour old?

[sois]

I am trying to write a script that deletes records that are an hour old. However, I am working on this project with somebody else and they don't use unix timestamps like I am used to. Rather, they use the SQL timestamp (2007-10-02 07:51:00) method.

How would you write a query that does what I am looking for?

Also how would I write a query that tells me the time left before expiration?

I don't like the SQL timestamp.

[NogDog]

Assuming MySQL as the DBMS and that the time column in the table is of type DATETIME or TIMESTAMP:

DELETE FROM table_name WHERE datetime_column < DATE_SUB(NOW(), INTERVAL 1 HOUR)

[sois]

That is perfect!

I just need this part and I'm set:
Also how would I write a query that tells me the time left before expiration?