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 [at] m .gmane.org
Re: Subtracting times
wot [at] 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.
--
Jamie McCarthy
http://mccarthy.vg/
jamie [at] 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 [at] m.gmane.org
Re: Subtracting times
wot [at] 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.
--
Jamie McCarthy
http://mccarthy.vg/
jamie [at] 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 [at] m.gmane.org
