Difference between two datestamps

[ziycon]

I have a date being returned from a mysql database like so

2009-12-29 13:59:23

I'm trying to check to see how many hours and minutes the current time has progressed since the datetime stamp was updated.

So something like:

print date("Y-m-d G:H:s") - '2009-12-29 13:59:23';

This always returns zero, any help much appreciated.

[code green]

date() returns a string so don't expect php to perform reliable arithmetic

This problems strikes me as better handled in MySQL using NOW() and TIMEDIFF()

SELECT TIMEDIFF(NOW() - `mydatefield`)

which I think returns the result in HH:MM:SS.ssss.
If it must be php then you will need timestamp arithmetic

time()-strtotime('my date value')

returning result in seconds

[ziycon]

Got what I wanted working using:

round((strtotime(date("Y-m-d G:H:s")) - strtotime($row['date']))/60 / 60)

Gives me a rough time line to work off which will do for what I need it. Thanks for your help.