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.
ediwup [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()
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)
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...
>
> mys
On Tue, Feb 15, 2005 at 06:48:08PM +0100, schlubediwup <[EMAIL PROTECTED]>
wrote:
> Hi again mysql-listers
>
>
> mysql> select addtime(now(), '00:60:00'); <<<
> ++
> | addtime(now(), '00:60:00') |
> ++
> | NULL
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
i3
