sql 語句:如何取當月的所有數據(50分)

goddy · 2001-07-10

select termdate form info where termdate like '2001-6%'
這句sql 錯誤

driver · 2001-07-10

如果你的 termdate 是date型
应当写 select termdate from info where datediff(mm,getdate(),termdate)=0

arm · 2001-07-10

select termdate form info where termdate between

date1 and

date2

Jedei · 2001-07-10

看这个：
Select termdate from info
where SubString(Convert(Char,termdate,120),1,7) ='2001-06'

张剑波 · 2001-07-10

有求每月最小日、最大日的自定义函数，然后代进去：
select termdate form info where termdate >= :mindate and termdate<=:maxdate

wind_cloudy · 2001-07-10

select termdate form info where month(termdate)=6

Jedei · 2001-07-10

受wind_cloudy启发
select termdate form info where year(termdate)=2001 and month(termdate)=6

gz_wh · 2001-07-10

select termdate form info where WHERE EXTRACT(MONTH FROM termdate) = 6

goddy · 2001-07-24

解決了