Postgres 16

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

set datestyle=MDY;
select '13.01.2010 15:08:44.997'::timestamptz;

SET

ERROR:  date/time field value out of range: "13.01.2010 15:08:44.997"
LINE 2: select '13.01.2010 15:08:44.997'::timestamptz;
               ^
HINT:  Perhaps you need a different "datestyle" setting.

select to_timestamp('13.01.2010 15:08:44.997',
                    'DD.MM.YYYY HH24:MI:SS.MS');

to_timestamp

2010-01-13 15:08:44.997+00

SELECT 1

set datestyle=ISO, DMY;
select '13.01.2010 15:08:44.997'::timestamptz;

SET

timestamptz

2010-01-13 15:08:44.997+00

SELECT 1