Subtracting times

How do I subtract two time from one another in MYSQL?

--
Kind Regards,
Otto

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Subtracting times

wot@dcs.kcl.ac.uk (Werner Otto) writes:

> How do I subtract two time from one another in MYSQL?

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.ht ml

TIMEDIFF() if your MySQL is 4.1.1 or later. Otherwise, maybe
convert both arguments to UNIX_TIMESTAMP() and subtract.
--=20
Jamie McCarthy
http://mccarthy.vg/
jamie@mccarthy.vg

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Subtracting times

wot@dcs.kcl.ac.uk (Werner Otto) writes:

> How do I subtract two time from one another in MYSQL?

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.ht ml

TIMEDIFF() if your MySQL is 4.1.1 or later. Otherwise, maybe
convert both arguments to UNIX_TIMESTAMP() and subtract.
--=20
Jamie McCarthy
http://mccarthy.vg/
jamie@mccarthy.vg

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org