SQL日期拼接问题

germ007 2013-01-05 12:09:47

rs.Open "select *, count(id) as A2_01 from [inf] where datediff(d,'"&year(dateadd("m",-1,year(date)&"-"&month(date)))&"-"&month(dateadd("m",-1,year(date)&"-"&month(date)))&"-24""','"&year(addtime) & "-" & right("0"&month(addtime),2) & "-" & right("0"&day(addtime),2)&"')<0",conn,1,1

选出上个月24号以后提交（ADDTIME）的信息，总是通不过

...全文

227 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

germ007 2013-01-05

打赏
举报

上月24日显示为2012-12-24，可是ADDTIME显示为1899-12-30

lzp4881 2013-01-05

打赏
举报

你用了select *又用了聚合函数count，当然通不过了。选出上个月24号以后的直接用>号就可以了，没必须搞那么麻烦。 SELECT * FROM [INF] WHERE dateAdd(d,0,[date])>'2012-12-24'

scscms太阳光 2013-01-05

打赏
举报

sql="SELECT *, count(id) as A2_01 from [inf] datediff('d',addtime,'"&dateadd("m",-1,year(date)&"-"&month(date)&"-24")&"')>0"

germ007 2013-01-05

打赏
举报

感觉应该是拼接的总是

germ007 2013-01-05

打赏
举报

SELECT * FROM [INF] WHERE (addtime > '"&year(dateadd("m",-1,year(date)&"-"&month(date)))&"-"&month(dateadd("m",-1,year(date)&"-"&month(date)))&"-24"&"') 显示“从字符串转换为DATETIME时出错”