By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
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