1. datetime转成date
convert(varchar(10),[create_date],120)
2.删除指定日期的数据
delete FROM student where convert(varchar(10),[create_date],120) ='2021-12-21'
1. datetime转成date
convert(varchar(10),[create_date],120)
2.删除指定日期的数据
delete FROM student where convert(varchar(10),[create_date],120) ='2021-12-21'