Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

version

PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE example (
    mouse bpchar(4),
    "date" bpchar(10),
    quantity int4
);

CREATE TABLE

INSERT INTO example VALUES
   ('1','31.01.2021',1),
   ('2','01.02.2021',2),
   ('3','31.12.2021',3),
   ('4','31.03.2021',4);

SELECT * FROM example

INSERT 0 4

mouse
date
quantity

1
31.01.2021
1

2
01.02.2021
2

3
31.12.2021
3

4
31.03.2021
4

SELECT 4

SELECT mouse, to_date("date",'DD.MM.YYYY'), quantity FROM example

mouse
to_date
quantity

1
2021-01-31
1

2
2021-02-01
2

3
2021-12-31
3

4
2021-03-31
4

SELECT 4

CREATE TABLE newexample AS SELECT mouse, to_date("date",'DD.MM.YYYY'), quantity FROM example;

SELECT 4

SELECT * FROM newexample;

mouse
to_date
quantity

1
2021-01-31
1

2
2021-02-01
2

3
2021-12-31
3

4
2021-03-31
4

SELECT 4