Re: Why is DATESTYLE, ordering ignored for output but used for input ?

2023-07-04 Thread Dave Cramer
On Mon, 3 Jul 2023 at 17:13, Matthias van de Meent < boekewurm+postg...@gmail.com> wrote: > On Mon, 3 Jul 2023 at 20:06, Dave Cramer wrote: > > > > Greetings, > > > > For ISO and German dates the order DMY is completely ignored on output > but used for input. > > > > test=# set datestyle to

Re: Why is DATESTYLE, ordering ignored for output but used for input ?

2023-07-03 Thread Matthias van de Meent
On Mon, 3 Jul 2023 at 20:06, Dave Cramer wrote: > > 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) > >

Why is DATESTYLE, ordering ignored for output but used for input ?

2023-07-03 Thread Dave Cramer
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 ;