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>
[EMAIL PROTECTED]:~> uname -a
Linux mydom 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
