lsxaa(小李铅笔刀) 不行的 2月只有28天JSDate BETWEEN '2005-02-1' AND '2005-02-30'就 会提示错误
那就 BETWEEN '2005-02-1' AND '2005-02-28'
BETWEEN '2005-02-1' AND '2005-03-1'
select sum(PH) as wat from Tab_m_outmwat WHERE (JSDate BETWEEN '2005-02-1' AND '2005-02-30') 如何获得一个月的数据合?或是一年的数据合 月的: select sum(PH) as wat from Tab_m_outmwat WHERE datepart(m,JSDate)=2 年的: select sum(PH) as wat from Tab_m_outmwat WHERE datepart(yyyy,JSDate)=2004
BETWEEN '2005-02-1' AND '2005-02-28'
月的:
select sum(PH) as wat from Tab_m_outmwat WHERE
datepart(m,JSDate)=2
年的:
select sum(PH) as wat from Tab_m_outmwat WHERE
datepart(yyyy,JSDate)=2004