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.