Do not use + for DATE arithmetic!
Use, for example
+ INTERVAL 1 YEAR
> -----Original Message-----
> From: hsv@stripped [mailto:hsv@stripped]
> Sent: Thursday, October 04, 2012 9:35 PM
> To: mysql@stripped
> Subject: date-IFNULL-sum bug?
>
> Can anyone explain this to me?
> The first one seems quite wrong; the rest make perfect sense.
>
> mysql> select ifnull(date('1900/5/3'), date('1900/01/01')) + 10000;
> +------------------------------------------------------+
> | ifnull(date('1900/5/3'), date('1900/01/01')) + 10000 |
> +------------------------------------------------------+
> | 11900 |
> +------------------------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql> select ifnull(date('1900/5/3'), date('1900/01/01'));
> +----------------------------------------------+
> | ifnull(date('1900/5/3'), date('1900/01/01')) |
> +----------------------------------------------+
> | 1900-05-03 |
> +----------------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql> select date('1900/5/3') + 10000;
> +--------------------------+
> | date('1900/5/3') + 10000 |
> +--------------------------+
> | 19010503 |
> +--------------------------+
> 1 row in set (0.00 sec)
>
> mysql> select date(date('1900/5/3') + 10000);
> +--------------------------------+
> | date(date('1900/5/3') + 10000) |
> +--------------------------------+
> | 1901-05-03 |
> +--------------------------------+
> 1 row in set (0.00 sec)
>
> (5.5.8 under muSoft Windows)
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
