How to find all the data in the specified month as fast as possible?

killch

data sheet:
ID DATETIME
1 2016-10-2
2 2016-10-12
3 2016-11-22
4 2016-12-17

What method can be used to find the data of 2016-10 as quickly as possible?

恶魔右指

select * from ta where convert(varchar(7),[datetime],120)='2016-10'

sinexe

--or
select * from ta where year([datetime])=2016 and month([datetime])=10

fanfan1980

select * from tbName where convert(char(7), DATETIME, 120)='2016-10'

快乐时间

that's it
select * from TableName where convert(char(7), DateTime, 120)='2016-10'

killch

Ask, what parameter is 120, how can I not find the help document?

The problem is solved, thank you all!

sami520119

select * from tabName where datediff(month,dtTime,'2016-10-1') = 0