Results 1 to 12 of 12
Sep 4, 2012, 09:26 #1
How do I get the time difference from a MySQL datetime field
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.
Anoox search engine volunteer