可用DATEDIFF函数来进行查询 语句大概是 SELECT * FROM Table WHERE DATEDIFF('d','2005-06-06') = 1 DATEDIFF的详细参数查阅SQL里的联机帮助即可
select * from LOG where (SELECT DateDiff(dd, ,LogDate,getdate())<=7) 一周 select * from LOG where (SELECT DateDiff(mm, ,LogDate,getdate())=0) 一月 sqlstr = "select * from LOG where LogDate=getdate() 今天 大家帮我看看,我哪儿写错了???
select * from LOG where DateDiff(dd, ,LogDate,getdate())<=7 一周 select * from LOG where DateDiff(mm, ,LogDate,getdate())=1 一月 select * from LOG where DateDiff(dd, ,LogDate,getdate())=0 今天
语句大概是
SELECT * FROM Table WHERE DATEDIFF('d','2005-06-06') = 1
DATEDIFF的详细参数查阅SQL里的联机帮助即可
select * from LOG where (SELECT DateDiff(mm, ,LogDate,getdate())=0) 一月
sqlstr = "select * from LOG where LogDate=getdate() 今天
大家帮我看看,我哪儿写错了???
select * from LOG where DateDiff(mm, ,LogDate,getdate())=1 一月
select * from LOG where DateDiff(dd, ,LogDate,getdate())=0 今天