识别年错误 [英] identifying year error

问题描述

嗨
我有一个sql表，我想查找不正确输入年份的记录，即输入1999作为19999的输入错误和类似的例子.

Hi
i have an sql table, i want to find the records where year is entered improperly ie 1999 is entered as 19999 the typing error and similar examples

推荐答案

正则表达式以实现tat.
可以通过在create语句中提供表达式来检查表达式.

You can go for regular expressions to achieve tat.
Can check the expression by providing it in the create statement its will do tat.

Select * from tablename where not datecolumn between '1900/1/1' and '2011/12/29' 

这篇关于识别年错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！