sql 删除某个日期字段小于今天的所有数据

delete FROM I_PRO_STVALUE WHERE　Datediff(day,CreateDate,GETDATE())>0