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
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)
>
>
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
;