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:[EMAIL PROTECTED] > Sent: Tuesday, February 15, 2005 11:48 > To: mysql@lists.mysql.com > 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> > > [EMAIL PROTECTED]:~> uname -a > Linux mydom 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 > i686 i686 > i386 GNU/Linux > [EMAIL PROTECTED]:~> > > > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]