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.