If I were U I would convert it to UNIX date first subtract and then restore
to normal format .... what do U think !?!?!
""Mikail"" <[EMAIL PROTECTED]> escreveu na mensagem
008c01c0d2f2$2e0df880$bb02a8c0@maz">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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
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]