|List:||General Discussion||« Previous MessageNext Message »|
|From:||hsv||Date:||October 9 2012 3:33am|
|Subject:||RE: date-IFNULL-sum bug?|
|View as plain text|
>>>> 2012/10/08 14:52 -0700, Rick James >>>> Do not use + for DATE arithmetic! Use, for example + INTERVAL 1 YEAR <<<<<<<< No, those operations are well defined. Amongst the timestamp-functions there is constant reference to numeric context, and character context--and well there is, because there are no time-constants, only numerals and character strings taken for timestamps. It is also the only means of doing some things.
|• date-IFNULL-sum bug?||hsv||5 Oct|
|• RE: date-IFNULL-sum bug?||Rick James||8 Oct|
|• RE: date-IFNULL-sum bug?||hsv||9 Oct|