List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:February 15 2005 6:10pm
Subject:Re: one hour is/is not 60 minutes, that's the question...
View as plain text  
In article <421235D8.5050605@stripped>,
schlubediwup <schlubediwup@stripped> writes:

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.

Nope.  Leap seconds do not accumulate to leap minutes; thus there's no
hour with 60 minutes.  I'm not sure about the silent conversion to
NULL; PostgreSQL throws an error stating 'interval field value out of
range: "00:60:00"'.

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