Hello,

How does one get the time difference in Hours from a MySQL date+time value which is kept in a datetime field?

To be exact, we have a field called:
date_added which is of datetime type

What we want to be able to do is:

SELECT id FROM xyz WHERE (Time_now is 6 Hours later than date_added) AND email_sent = 'no'

Of course "Time_now is 6 Hours later than date_added" is not MySQL
Just what we are trying to achieve.


Regards,