Hi All, Yes, they are mysql timestamps. I'll just use the query John suggested and modify it to fit my needs. I was originally going to do something like Martin suggested, but if I can do it right in MySQL, I'll do it that way.
Thanks all! tyler ----- Original Message ----- From: "1LT John W. Holmes" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]>; "php-general" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 10:09 AM Subject: Re: [PHP] days between two timestamps > 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
