mysql 某周的起始和结束日期 有数据如下:year Week2011 22011 32011 42011 5想知道2011年的第二周起始日期和结束日期是哪2个?求帮助 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT year, week, x.start, ADDDATE(x.start, 6) AS end FROM ( SELECT ADDDATE(jan1, (t.week - WEEK(jan1, 5)) * 7 - WEEKDAY(jan1)) AS start, year, week FROM (SELECT MAKEDATE(`year`, 1) AS jan1, year, week FROM t_table) t ) x;+------+------+------------+------------+| year | week | start | end |+------+------+------------+------------+| 2011 | 1 | 2011-01-03 | 2011-01-09 || 2011 | 2 | 2011-01-10 | 2011-01-16 || 2011 | 3 | 2011-01-17 | 2011-01-23 || 2011 | 52 | 2011-12-26 | 2012-01-01 |+------+------+------------+------------+ 其中week(date, mode) 函数的含义:http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_week qtcreator mysql dll 使用mysql_pconnect链接数据库,内存会无限增加,直到拖挂服务器 各位大神紧急求助,看看我这样写对不对。 高分求教 MySql 的 BLOB字段读取问题(在线等)?????? 求在MYSQL调用发送短信的接口的写法 请教一个问题 查询 MYSQL5.0下怎么创建存储过程? 请问juilder怎么连接mysql数据库??急! 【求助】order by , group by 后 怎么设置一组数据内的序号 地理位置经纬度在Mysql中用什么字段类型来存,BOOLEAN ?DOUBLE?还是FLOAT 那种最好为什么? 奇怪问题,急求答案
FROM (
SELECT ADDDATE(jan1, (t.week - WEEK(jan1, 5)) * 7 - WEEKDAY(jan1)) AS start, year, week
FROM (SELECT MAKEDATE(`year`, 1) AS jan1, year, week FROM t_table) t
) x;+------+------+------------+------------+
| year | week | start | end |
+------+------+------------+------------+
| 2011 | 1 | 2011-01-03 | 2011-01-09 |
| 2011 | 2 | 2011-01-10 | 2011-01-16 |
| 2011 | 3 | 2011-01-17 | 2011-01-23 |
| 2011 | 52 | 2011-12-26 | 2012-01-01 |
+------+------+------------+------------+