Oracle正则过滤日期
create table date_regexp_test(
birth_date varchar(255)
);
insert into date_regexp_test values ('3993-01-12');
insert into date_regexp_test values ('1993-13-12');
insert into date_regexp_test values ('1993-01-32');
insert into date_regexp_test values ('1993-01-12');
insert into date_regexp_test values ('1989-01-01');
insert into date_regexp_test values ('1990-01-01');
insert into date_regexp_test values ('2000-01-01');
insert into date_regexp_test values ('2010-01-01');
insert into date_regexp_test values ('2020-01-01');
commit;
select * from date_regexp_test where regexp_like(birth_date,'\d{4}-(0[1-9]|1[0-2])-(0[1-9]|(1|2)[0-9]|3(0|1))');
select * from date_regexp_test where regexp_like(birth_date,'(199[0-9]|20(0|1)[0-9]|2020)-(0[1-9]|1[0-2])-(0[1-9]|(1|2)[0-9]|3(0|1))');