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.

Thread
date-IFNULL-sum bug?hsv5 Oct
  • RE: date-IFNULL-sum bug?Rick James8 Oct
    • RE: date-IFNULL-sum bug?hsv9 Oct