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 should set the default_week_format. This command fails:
mysql> set global default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql> select week('2003-08-14');
+--------------------+
| week('2003-08-14') |
+--------------------+
| 32 |
+--------------------+
1 row in set (0.00 sec)
This result is incorrect. It should be 33.
If I use:
mysql> set session default_week_format=3;
Query OK, 0 rows affected (0.00 sec)
mysql> select week('2003-08-14');
+--------------------+
| week('2003-08-14') |
+--------------------+
| 33 |
+--------------------+
1 row in set (0.00 sec)
This is result is correct...
I use mysql 4.0.14. I also did the same test on mysql 4.1 alpha, which has
the same results.
Can somebody help?
Thanks,
Harm de Laat
Informatiefabriek
The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw