By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | birthdate | DOB |
---|---|---|
1 | 1991-01-23 | null |
2 | yyyy-01-23 | null |
3 | 1991-mm-23 | null |
4 | 1991-01-dd | null |
5 | null | |
6 | 1991-01-d3 | null |
7 | 1983-05-23 | null |
8 | 1991-0m-23 | null |
9 | 19yy-01-23 | null |
10 | y991-01-23 | null |
11 | 1993/03/20 | null |
12 | 2000/09/25 | null |
13 | 2015.06.30 | null |
14 | 2015_04_15 | null |
total_crap |
---|
1992 |
1 |
1991 |
1992 |
0 |
1992 |
1988 |
1991 |
20 |
1 |
1996 |
2009 |
2021 |
2019 |
dat_str |
---|
1991-01-23 |
null |
null |
null |
null |
null |
1983-05-23 |
null |
null |
null |
1993-03-20 |
2000-09-25 |
2015-06-30 |
2015-04-15 |
id | birthdate | DOB |
---|---|---|
1 | 1991-01-23 | 1991-01-23 |
2 | yyyy-01-23 | 2020-01-01 |
3 | 1991-mm-23 | 2020-01-01 |
4 | 1991-01-dd | 2020-01-01 |
5 | 2020-01-01 | |
6 | 1991-01-d3 | 2020-01-01 |
7 | 1983-05-23 | 1983-05-23 |
8 | 1991-0m-23 | 2020-01-01 |
9 | 19yy-01-23 | 2020-01-01 |
10 | y991-01-23 | 2020-01-01 |
11 | 1993/03/20 | 1993-03-20 |
12 | 2000/09/25 | 2000-09-25 |
13 | 2015.06.30 | 2015-06-30 |
14 | 2015_04_15 | 2015-04-15 |