Retrieve data by fuzzy query

mlw3031

I want to write a date specific to the year and month and then retrieve the data. In ms-sql,
My date field type smalldatetime type

Is it written like this, select * from where date like '% 2006-12%'

cv4bf5d65fd

select * from where convert (char (7), date, 21) like '2006-12'

mlw3031

Thanks, solved

恶魔右指

select * from ta where convert (varchar (6), time column, 112) = '200701'

恶魔右指

Time conversion is so efficient
The landlord can refer to the online help
About time conversion (using convert)