SQL如何统计本月的数据 ( 积分: 100 )

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-14

• #1

SQL如何统计本月的数据
或查询本月的数据

 

C

Corn3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #2

总有一个字段存日期的吧？假设是DateField
查询条件：
where DateField between Convert(varchar(8), getdate(), 120)+'01' and Convert(varchar(8), getdate(), 120)+Convert(Day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))) as varchar)

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #3

SQL SERVER
where year(日期) = year(getdate()) and month(日期) = month(getdate())
ACCESS
where year(日期) = year(now) and month(日期) = month(now)

 

C

Corn3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #4

晕，俺们咋没想到呢...