UC知道求sql查询代码
来源：百度知道 编辑：UC知道 时间：2024/05/04 12:35:07
我有张表juke,有字段月mm，日dd.现在想查询本月的信息，今天的信息。
sql怎么写
select * from phome_ecms_jieri where mm=Month(now())这句正常
select * from phome_ecms_jieri where dd=Day(now())这句出现出错！！SQL Error: select * from phome_ecms_jieri where dd=Day(now())日期也是字型的。。。。。。。。。
sql怎么写
select * from phome_ecms_jieri where mm=Month(now())这句正常
select * from phome_ecms_jieri where dd=Day(now())这句出现出错！！SQL Error: select * from phome_ecms_jieri where dd=Day(now())日期也是字型的。。。。。。。。。
mstr=month(now())
dstr=day(now())
关于本月的信息
sql="select * from juke where mm='"&mstr&"'"
关于今天的信息
sql="select * from juke where mm='"&mstr&"' and dd='"&dstr&"'"
老大,你的是
select * from phome_ecms_jieri where mm=Month(now())
select * from phome_ecms_jieri where dd=Day(now())
和我给的代码完全不一样嘛,改成那样当然会出错了
select * from juke where mm="&month(now)