求某个月有多少天 我是想求某个月有多少天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')然后使用 请问一下MYSQL比较好用的备份还原方法是哪种? mysql无法连接,快急疯了 Mysql中,判断表是否存在。 求SQL语句 [MySQL]如何恢复二进制数据 在线等:mysql里面有没有类似sql server 中的@@IDENTITY这样的方法,可以取得最近插入的id ,解决即给分 如果postgresql编码是unicode, 分类统计(group by)、distinct遇到汉字就不正确了,如何解决 ADO连接MYSQL出现灾难性故障!! float类型的字段如何使插入的记录值为空呢??? mysql的遍历次数问题 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')然后使用