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

Reply via email to