How can I use the output string of the yearweek() function
(for example, "200346" below):
mysql> select dayname("2003-11-12"), yearweek("2003-11-12");
+-----------------------+------------------------+
| dayname("2003-11-12") | yearweek("2003-11-12") |
+-----------------------+------------------------+
| Wednesday | 200346 |
+-----------------------+------------------------+
1 row in set (0.00 sec)
to extract the start and end dates for that week (for example, "2003-11-09"
and "2003-11-15" above)?
I'm using server v3.23.
--
Trevor Smith | [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
