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