SELECT COUNT(field) FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30 改变后面的时间天数和起始时间,就可以得到你想要的查寻了。
SELECT Sum(num) AS total FROM test WHERE Month(datetime)=3 AND Year(datetime=2003)
这可以按年度进行显示. SELECT Sum(num) AS total FROM test WHERE Year(datetime=2003)按季度 SELECT Sum(num) AS total FROM test WHERE (Month(datetime)>=1 AND Month(datetime)<=3) AND Year(datetime=2003) 也可以用DatePart DatePart("yyyy",TheDate) 取得年 DatePart("q",TheDate) 季度 DatePath("m",TheDate) 月 再进行判断.
改变后面的时间天数和起始时间,就可以得到你想要的查寻了。
FROM test
WHERE Month(datetime)=3 AND Year(datetime=2003)
SELECT Sum(num) AS total
FROM test
WHERE Year(datetime=2003)按季度
SELECT Sum(num) AS total
FROM test
WHERE (Month(datetime)>=1 AND Month(datetime)<=3) AND Year(datetime=2003)
也可以用DatePart
DatePart("yyyy",TheDate) 取得年
DatePart("q",TheDate) 季度
DatePath("m",TheDate) 月
再进行判断.