Re: mysql 4.x week function fails

2003-08-18 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: > > I think there is a bug in mysql 4: > > select week("2003-08-15") from po.orders limit 1; > > produces: 32 > > after: > > set session default_week_format=3; > > it produces: 33 (which is correct in the Netherlands) > > The documentation states: > > set global de

mysql 4.x week function fails

2003-08-18 Thread harm
Hi all, I think there is a bug in mysql 4: select week("2003-08-15") from po.orders limit 1; produces: 32 after: set session default_week_format=3; it produces: 33 (which is correct in the Netherlands) The documentation states: set global default_week_format=3; (As root!) This command sho