| 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? | hsv | 5 Oct |
| • RE: date-IFNULL-sum bug? | Rick James | 8 Oct |
| • RE: date-IFNULL-sum bug? | hsv | 9 Oct |
