<laughs> Well, I had the right idea... John is just more advance than me. :o)
>>> "1LT John W. Holmes" <[EMAIL PROTECTED]> 06/05/02 11:09AM >>> Since those look like MySQL timestamps, I would suggest you do it in your query. SELECT TO_DAYS(column1) - TO_DAYS(column2) AS Difference FROM table Adapt to your needs. Explain what your overall mission is and there is probably a query that'll return just that. If you want to use PHP, format those timestamps into something strtotime() will convert to a unix timestamp, find the difference in seconds, and convert the number of seconds into days. ---John Holmes... ----- Original Message ----- From: "Tyler Longren" <[EMAIL PROTECTED]> To: "php-general" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 11:01 AM Subject: [PHP] days between two timestamps > Hi, > > I have two different timestamps: > 20020603164114 > and > 20020605054710 > > Is there a simple way to get the number of days between the two dates? > > thanks, > tyler > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
