In article <[EMAIL PROTECTED]>, schlubediwup <[EMAIL PROTECTED]> 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"'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]