Page 1 of 1

How do you get the time passed ?

Posted: Wed Jan 30, 2008 5:01 am
by scheinarts
If you have a in the MySQL data base a column called created_date, which gets stores the created time of the row... how do I determine the elapsed days or hours or minutes since that record was created from the current time now?

Re: How do you get the time passed ?

Posted: Wed Jan 30, 2008 5:17 am
by aceconcepts

Re: How do you get the time passed ?

Posted: Wed Jan 30, 2008 9:19 am
by scheinarts
i checked it out but im not clear on how it would work for what i need it to do. Can some one maybe post an example

Re: How do you get the time passed ?

Posted: Wed Jan 30, 2008 9:45 am
by pickle
UNIX timestamps are seconds. So subtracting the time of creation from the now, you'll get the elapsed seconds.