how to count age

[mobilaku]

dear all,

i'm a beginner on php and mysql.
i have a problem to count age of my data.
here is the example : i want t know how many days are my record in database. i mean i want to count a field ( date_in ) - date today ( or input date ) and the result is on days.

pls help me.

many thanks
Anggi

[Banfa]

Something like


SELECT TO_DAYS(NOW())-TO_DAYS(post-date) AS DaysSincePost From YourTable;

[rkagrawal]

The solution given by Banfa will do the purpose.
If you want to try something else , get the first time + date in seconds , second time + date in seconds . Get their difference in seconds and convert the seconds into days .

I hope it helps someone.


Rahul Agrawal
Developer
Web2003 Corporation
www.web2003corp .com

[mobilaku]

Something like


SELECT TO_DAYS(NOW())-TO_DAYS(post-date) AS DaysSincePost From YourTable;

thank you very much, it's worked.