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
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 |
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
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)
[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
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.00 sec)