>>>> 2012/07/24 13:07 -0700, Hassan Schroeder >>>>
On Tue, Jul 24, 2012 at 10:36 AM, Roberta Jask
> version(): 5.5.8-log
> What is yours?
@@sql_mode is empty
Well, the answer to my original question is that MySQL is willind with a warning to
"narrow" DATE to YEAR, but with my usual setting, with STRICT_TRANS_TABLES, the warning
becomes an error. As for widening YEAR to DATE, MySQL never does it: with a warning it is
willind to return the 0-date for an attempt at widening, but, with STRICT_TRANS_TABLES, as
erst, the warning becomes an error. It would be better if MySQL were willind also to
widen: if, say, the YEAR were 1967, it would be widened to 1967-00-00. Too bad.