List:General Discussion« Previous MessageNext Message »
From:Tom Crimmins Date:February 15 2005 6:07pm
Subject:RE: one hour is/is not 60 minutes, that's the question...
View as plain text  
The minute part of a time expression only has a valid range of 0 to 59.

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

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
 

> -----Original Message-----
> From: schlubediwup [mailto:schlubediwup@stripped] 
> Sent: Tuesday, February 15, 2005 11:48
> To: mysql@stripped
> Subject: one hour is/is not 60 minutes, that's the question...
> 
> 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