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

Reply via email to