Re: mysql-php
| From: | Nickolas Heyde | Date: | Wed, 09 May 2001 23:13:35 +0000 |
| Subject: | Re: mysql-php | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9236@lists.php.net to get a copy of this message | ||
If I were U I would convert it to UNIX date first subtract and then restore
to normal format .... what do U think !?!?!
""Mikail"" <mikail@box.it> escreveu na mensagem
news:008c01c0d2f2$2e0df880$bb02a8c0@maz...
> hi,
> I'm a newbie from Italy
> I use php with mysql and I need to find a way to visualize the difference
> between two dates.
> For ex in a row I have column [A] and column [B]
> [A] 2001-05-02 10:00:00
> [B] 2001-05-02 10:01:30
> If I use
> SELECT TIME_FORMAT([B]-[A], '%H:%i:%s') result is 00:01:30
> But it's the same if I use SELECT TIME_FORMAT([A]-[B], '%H:%i:%s')
> why? I need a - (minus)!
> Thanks
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>