List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 26 1999 2:18pm
Subject:yearweek() function
View as plain text  
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
Thread
yearweek() functionMichael Widenius26 Dec