Greetings,
For ISO and German dates the order DMY is completely ignored on output but
used for input.
test=# set datestyle to 'ISO,DMY';
SET
select '7-8-2023'::date
test-# ;
date
------------
2023-08-07
(1 row)
test=# set datestyle to 'ISO,MDY';
SET
test=# select '7-8-2023'::date
;
date
------------
2023-07-08
(1 row)
Note regardless of how the ordering is specified it is always output as
YMD
Dave Cramer