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.