Is the DATE_ADD(time, INTERVAL) an option?
SELECT Now(), DATE_ADD(Now(), interval 60 minute)
schlubediwup wrote:
> Hi again mysql-listers
>
>
> mysql> select version();
> +--------------------+
> | version() |
> +--------------------+
> | 4.1.9-standard-log |
> +--------------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> cellino@mydom:~> uname -a
> Linux mydom 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686
> i686 i386 GNU/Linux
> cellino@mydom:~>
>
>
>
> 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
>
>
>
>
