Posted by Nel on 06/09/06 11:14

Hi,

I am trying to access the records from a database for the last hours updates
using the following code.

SELECT * FROM `log` WHERE (
unix_timestamp(now() - 3600) < unix_timestamp(timevisited)
)

It doesn't seem to be working correctly. It returns all results (going back
a few hours to when I started the log table).

Am I making some basic mistake?

Nel.

[Back to original message]