Select using time differences

[Barry]

Hi,

I could not find how to calculate the time difference between NOW() and a
TimeStamp column using the Date Time Functions listed in the docs. I am
using the latest NT version of mysql.

I would like to do the following Select (only correctly, of course :) )

where: TSVal is a TimeStamp column in my table

Select * from .... where Now() - TSVal <= 24 hours

  (24 hours or 1440 minutes or 86400 seconds)


suppose Now() is June 17 1999  20:30:00
        TSVal is June 16 1999  11:30:00

The difference is 118800 seconds (if I did the math correctly :) ), so my
Select would not return the row.

Any suggestions or pointers.

Thanks much,
Barry.