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
