Getting amount of hours since date?

[Fenhopi]

Hi, I have a database where I store times with the Now(); function.

 

What I want is:

When the viewer looks at the post, instead of it saying: Posted: 2010-11-14 19:08:14,

I want it to say posted: x hours ago, Posted: x days ago, etc.

 

Any help with this would be appreciated!

[PFMaBiSmAd]

You can simply calculate the differences in your query and then use the information any way you want when you display it (i.e. if days are zero, display the hours...) -

SELECT TIMESTAMPDIFF(HOUR,now(),your_datetime_column) as hours, TIMESTAMPDIFF(DAY,now(),your_datetime_column) as days

[Fenhopi]

Thank you, man!

How would I remove the - in front of number though?

 

if($Time contains("-"){

Don't know how to post number without - symbol

}

[PFMaBiSmAd]

I would reverse the order of the two arguments (it calculates datetime_expr2 – datetime_expr1.)

 

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

 

 

[Fenhopi]

Thank you! Highly appreciate it!