求某个月有多少天 我是想求某个月有多少天select date_add(ms,-3,date_add(mm, DATEDIFF(m,0,GETDATE())+1,0))) 这句话哪里错了啊,我运行时总出错然后如何循环出每天啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 LZ写的是什么? "ms mm m"能这么写? getdate()你写的函数? 完全不知所云 mysql> select day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day));+-----------------------------------------------------------------------------------------------------+| day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day)) |+-----------------------------------------------------------------------------------------------------+| 31 |+-----------------------------------------------------------------------------------------------------+1 row in set (0.00 sec) --按你的写法这么写..mysql> select dayofmonth(date_add(date_add('1000-01-01',interval timestampdiff(month,'1000-01-01',now())+1 month), interval -1 day)); mysql> SELECT day(LAST_DAY('2004-02-05'));+-----------------------------+| day(LAST_DAY('2004-02-05')) |+-----------------------------+| 29 |+-----------------------------+1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2003-02-05'));+-----------------------------+| day(LAST_DAY('2003-02-05')) |+-----------------------------+| 28 |+-----------------------------+1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2010-08-05'));+-----------------------------+| day(LAST_DAY('2010-08-05')) |+-----------------------------+| 31 |+-----------------------------+1 row in set (0.00 sec)mysql> mysql> SELECT day(LAST_DAY(now()));+----------------------+| day(LAST_DAY(now())) |+----------------------+| 31 |+----------------------+1 row in set (0.00 sec)mysql> 那不一样么 只要把你的时间补全比如2010年9月改成 concat('2010-09','-01')然后使用 关于update的问题 MySQL在多个索引的情况下的默认排序规则是什么?能否指定默认排序索引? 如何配置mysql使其占有更多资源 MySql中还原、备份、复制的问题 求助~~!想要一个SQL语句。 请问怎么插入一系列随机数? ************做个MYSQL的调查************** mysql数据库异地同步 数据查询求教,请大侠帮忙,急 已dayofmonth来分区,查询时无效? mysql正则表达式查询求助 大家帮忙看看这个SQL查询怎么写
mysql> select day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day));
+-----------------------------------------------------------------------------------------------------+
| day(date_add(date_add(concat(date_format(now(),'%Y-%m'),'-01') ,interval 1 month),interval -1 day)) |
+-----------------------------------------------------------------------------------------------------+
| 31 |
+-----------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT day(LAST_DAY('2004-02-05'));
+-----------------------------+
| day(LAST_DAY('2004-02-05')) |
+-----------------------------+
| 29 |
+-----------------------------+
1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2003-02-05'));
+-----------------------------+
| day(LAST_DAY('2003-02-05')) |
+-----------------------------+
| 28 |
+-----------------------------+
1 row in set (0.00 sec)mysql> SELECT day(LAST_DAY('2010-08-05'));
+-----------------------------+
| day(LAST_DAY('2010-08-05')) |
+-----------------------------+
| 31 |
+-----------------------------+
1 row in set (0.00 sec)mysql>
mysql> SELECT day(LAST_DAY(now()));
+----------------------+
| day(LAST_DAY(now())) |
+----------------------+
| 31 |
+----------------------+
1 row in set (0.00 sec)mysql>
只要把你的时间补全比如2010年9月
改成 concat('2010-09','-01')然后使用