yearweek() function

[Michael Widenius]

Hi!

We had a while ago a discussion about a yearweek() function.  I just
wanted to inform you that I just added a yearweek() function and
year-week handling to date_format() to MySQL 3.23.8

mysql> select yearweek('1981-12-31',1);
+--------------------------+
| yearweek('1981-12-31',1) |
+--------------------------+
|                   198153 |
+--------------------------+
1 row in set (0.03 sec)


mysql> select date_format('1999-01-01',"%x-%v");
+-----------------------------------+
| date_format('1982-01-01',"%x-%v") |
+-----------------------------------+
| 1998-53                           |
+-----------------------------------+

Regards,
Monty