1.查询今日(传入’2020-11-14 10:00:00.0000000’,但只会截取2020-11-14 去查询)
convert(varchar(10), createdate, 120) = convert(varchar(10), ‘2020-11-14 10:00:00.0000000’, 120)
SqlServer 日期函数
最新推荐文章于 2024-02-01 18:56:28 发布
1.查询今日(传入’2020-11-14 10:00:00.0000000’,但只会截取2020-11-14 去查询)
convert(varchar(10), createdate, 120) = convert(varchar(10), ‘2020-11-14 10:00:00.0000000’, 120)