SQL Server dateTime类型 模糊查询

 

select * from 表名 where   Convert(varchar,birthday,120) LIKE '%-01-10%'

 

 

 

 

具体语法 https://docs.microsoft.com/zh-cn/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver15