mysql-php
| From: | Mikail | Date: | Wed, 02 May 2001 10:24:45 +0000 |
| Subject: | mysql-php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9044@lists.php.net to get a copy of this message | ||
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