Re: days between two timestamps

<laughs> Well, I had the right idea... John is just more advance than me. :o) >>> "1LT John W. Holmes" <holmes072000@charter.net> 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" <tyler@captainjack.com> To: "php-general" <php-general@lists.php.net> 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