You still haven't told us which database server you are using...

If you are using Sybase or MS-SQL then you should be aware that TIMESTAMP has nothing to do with a time or date value, which would also cause your query to behave strangely (it's a binary counter that is guaranteed to change every time the row is updated).

Michael