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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
