sql server筛选数据里面不符合日期格式的字段

--先判断长度是不是长了或者短了
select * from ZY_BRSYK
WHERE LEN(birth) <> 8
--再判断每一个小节点是不是在范围之内
select * from ZY_BRSYK
WHERE not SUBSTRING(birth,1,4) BETWEEN '1900' AND '2020' or not SUBSTRING(birth,5,2) BETWEEN '01' AND '12' or not SUBSTRING(birth,7,2) BETWEEN '01' AND '31'