Postgres 16

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

ERROR:  column "version" does not exist
LINE 1: select @@version;
                 ^

CREATE TABLE sample_dates (
    original_date TEXT
);

CREATE TABLE

INSERT INTO sample_dates (original_date)
VALUES
    ('18.02.2024 10:10:40.409'),
    ('01.01.2024 00:06:09.125'),
    ('23.03.2023 12:30:15.987'),
    ('15.07.2022 08:20:10.345'),
    ('09.08.2021 18:55:00.555');

INSERT 0 5

select * from sample_dates ;

original_date

18.02.2024 10:10:40.409

01.01.2024 00:06:09.125

23.03.2023 12:30:15.987

15.07.2022 08:20:10.345

09.08.2021 18:55:00.555

SELECT 5

SELECT TO_TIMESTAMP(original_date, 'DD.MM.YYYY HH24:MI:SS.MS') from sample_dates;

to_timestamp

2024-02-18 10:10:40.409+00

2024-01-01 00:06:09.125+00

2023-03-23 12:30:15.987+00

2022-07-15 08:20:10.345+00

2021-08-09 18:55:00.555+00

SELECT 5

ALTER TABLE sample_dates
ADD COLUMN new_original_date TIMESTAMP;

ALTER TABLE

UPDATE sample_dates
SET new_original_date = TO_TIMESTAMP(original_date, 'DD.MM.YYYY HH24:MI:SS.MS');

UPDATE 5

ALTER TABLE sample_dates
DROP COLUMN original_date;

ALTER TABLE

select * from sample_dates;

new_original_date

2024-02-18 10:10:40.409

2024-01-01 00:06:09.125

2023-03-23 12:30:15.987

2022-07-15 08:20:10.345

2021-08-09 18:55:00.555

SELECT 5