[access查询]用SQL语句来设置本月/上月第一天及上月本月/上月最后一天

时　间:2008-09-08 17:07:17
作　者:十段   ID：563  城市：上海
摘　要:用SQL语句来设置本月/上月第一天及上月本月/上月最后一天
正　文:

Select DateSerial(Year(Date()),Month(Date())+1,1)-1 AS 本月最后一天, Date()-Day(Date())+1 AS 本月第一天, DateSerial(Year(Date()),Month(Date()),1)-1 AS 上月最后一天, DateSerial(Year(Date()),Month(Date())-1,1) AS 上月第一天
FROM dbo_gc_rbs
GROUP BY DateSerial(Year(Date()),Month(Date())+1,1)-1, Date()-Day(Date())+1, DateSerial(Year(Date()),Month(Date()),1)-1, DateSerial(Year(Date()),Month(Date())-1,1);