Postgres Pro
Downloads
Home   >   mailing lists

Why is DATESTYLE, ordering ignored for output but used for input ? - Mailing list pgsql-hackers

From Dave Cramer
Subject Why is DATESTYLE, ordering ignored for output but used for input ?
Date
Msg-id CADK3HH+Ev=ZM-mru1gRRBHy+ur54NcuFZNa_bHRgtUJP82YoGA@mail.gmail.com
Whole thread Raw
Responses Re: Why is DATESTYLE, ordering ignored for output but used for input ?
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: "Tristan Partin"
Date:
Subject: Re: Optionally using a better backtrace library?
Next
From: Nathan Bossart
Date:
Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations.