There is an option in MySQL.
That is DATE_DIFFERENCE function. You can pass two date to that function in a SELECT query.
Please check with MySQL manual.
Thanks & Regards
Udayakumar Sarangapani
Sr. PHP Developer
CompIndia Infotech Pvt. Ltd.
Chennai.
"Science is nothing but logic..."
________________________________
From: Jean Carlo <jsalas@xxxxxxxxxxxxxxxxxx>
To: php-objects@xxxxxxxxxxxxxxx
Sent: Wednesday, 22 October, 2008 1:29:57 AM
Subject: Get Time betwen dates
Hi all pros, I want subtract 2 Dates on PHP but I want that the result give
me:
I introduce a old date "2007-09-19" and today's date (2008-10-21) .
And the function returs: 1 year, 1month and 2 day.
Did you know or have any function to do that?
Regards! ^.^
[Non-text portions of this message have been removed]
Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
[Non-text portions of this message have been removed]
