[nzlug] Time Calculator

[Michal Ludvig]

Marvin Pascual wrote:
> Hello all,
> 
> Anyone here knows if there's such tool as a "time calculator" that can
> do at least the basic calculations for HH:MM:SS:MS?

I use mysql for that ;-)

mysql> select adddate("2007-01-11 11:50", interval 30 hour);
+-----------------------------------------------+
| adddate("2007-01-11 11:50", interval 30 hour) |
+-----------------------------------------------+
| 2007-01-12 17:50:00                           |
+-----------------------------------------------+

It's quite powerful but I admit not really lightweight ;-)

BTW http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Michal