Hello, > mysql> select version(); > +--------------------+ > | version() | > +--------------------+ > | 4.1.9-standard-log | > +--------------------+ > 1 row in set (0.00 sec) > > mysql>
Although I'm not fully aware of MySQL time/date symantecs, I would like to make a comment... > > 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'); <<<<<<<<<<<<<<<<<<< There's no such time. 00:60:00 is a duration, not a time. So I too wonder what the warning was... > +----------------------------+ > | addtime(now(), '00:60:00') | > +----------------------------+ > | NULL | > +----------------------------+ > 1 row in set, 1 warning (0.00 sec) > > mysql> select addtime(now(), '01:00:00'); This is a valid time. Namely, 01:00 AM. > +----------------------------+ > | 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. Perhaps there's another function to add durations? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]