DECLARE @InputDate varchar(20)
SET @InputDate = ''
SELECT Id,DateField,Name,Age FROM CustInfo
WHERE CONVERT(char, DateField , 20) like '%' + Replace(@InputDate,'-','%') + '%'
SQL按时间模糊查询
最新推荐文章于 2024-09-12 00:09:34 发布
DECLARE @InputDate varchar(20)
SET @InputDate = ''
SELECT Id,DateField,Name,Age FROM CustInfo
WHERE CONVERT(char, DateField , 20) like '%' + Replace(@InputDate,'-','%') + '%'