Hi again mysql-listers
mysql> select version();
+--------------------+
| version() |
+--------------------+
| 4.1.9-standard-log |
+--------------------+
1 row in set (0.00 sec)
mysql>
cellino@mydom:~> uname -a
Linux mydom 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 i686
i386 GNU/Linux
cellino@mydom:~>
mysql> select addtime(now(), '00:00:00');
+----------------------------+
| addtime(now(), '00:00:00') |
+----------------------------+
| 2005-02-15 16:49:17 |
+----------------------------+
1 row in set (0.00 sec)
mysql> select addtime(now(), '00:60:00');
> <<<<<<<<<<<<<<<<<<<
+----------------------------+
| addtime(now(), '00:60:00') |
+----------------------------+
| NULL |
+----------------------------+
1 row in set, 1 warning (0.00 sec)
mysql> select addtime(now(), '01:00:00');
+----------------------------+
| addtime(now(), '01:00:00') |
+----------------------------+
| 2005-02-15 17:50:27 |
+----------------------------+
1 row in set (0.00 sec)
in my opinion the result of the second and third example above must be
the same.
suomi
