List:General Discussion« Previous MessageNext Message »
From:schlubediwup Date:February 15 2005 5:48pm
Subject:one hour is/is not 60 minutes, that's the question...
View as plain text  
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



Thread
one hour is/is not 60 minutes, that's the question...schlubediwup15 Feb
  • Re: one hour is/is not 60 minutes, that's the question...Rich Lafferty15 Feb
  • Re: one hour is/is not 60 minutes, that's the question...Martijn Tonies15 Feb
  • Re: one hour is/is not 60 minutes, that's the question...Victor Pendleton15 Feb
  • Re: one hour is/is not 60 minutes, that's the question...Harald Fuchs15 Feb
RE: one hour is/is not 60 minutes, that's the question...Tom Crimmins15 Feb