MIME-Version: 1.0
References: 
 <CAPhCW+-oyivUiBiP5nOMQNxQzXLnT62SvCZ1oq7rqZkHq34KGA@mail.gmail.com>
 <CAB=Je-Gznb3j_M--EAn9zW0cHLzgMg_YyWxWGM==g_kRfxEzrA@mail.gmail.com>
 <CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA@mail.gmail.com>
In-Reply-To: 
 <CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA@mail.gmail.com>
From: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Date: Mon, 19 May 2025 18:37:24 +0300
Message-ID: 
 <CAB=Je-EmfXoyBRm2LefkxugqNGPta7vf=Ky8ycYpkd02_-WX_w@mail.gmail.com>
Subject: Re: Understanding DateStyle guc in startup packet
To: Dave Cramer <davecramer@postgres.rocks>
Cc: Manav Kumar <mkumar@yugabyte.com>, pgsql-jdbc@lists.postgresql.org,
	Laurenz Albe <laurenz.albe@cybertec.at>
Content-Type: multipart/alternative; boundary="0000000000003cf14406357ee963"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB%3DJe-EmfXoyBRm2LefkxugqNGPta7vf%3DKy8ycYpkd02_-WX_w%40mail.gmail.com>
Precedence: bulk

--0000000000003cf14406357ee963
Content-Type: text/plain; charset="UTF-8"

>Why would you want to change it?

Applications might have their own view on the way DateStyle connection
property should be set.
It could make a difference if the app uses things like select
'03-05-2025'::date.

Of course, it would be great if the app code could resist from casting text
to dates, however,
I think the driver should stand in the way there by enforcing a very
specific DateStyle value.

To me, DateStyle looks like timezone, and client_encoding which we
currently enforce, yet we could do better and skip enforcing the values.

Vladimir

--0000000000003cf14406357ee963
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>&gt;Why would you want to change it?=
</div><div><br></div><div>Applications might have their own view on the way=
 DateStyle connection property should be set.</div><div>It could make a dif=
ference if the app uses things like select &#39;03-05-2025&#39;::date.<br><=
br></div><div>Of course, it would be great if the app code could resist fro=
m casting text to dates, however,</div><div>I think the driver should stand=
 in the way there by enforcing a very specific DateStyle value.</div><div><=
br></div><div>To me, DateStyle looks like timezone, and=C2=A0client_encodin=
g which we currently enforce, yet we could do better and skip enforcing the=
 values.</div><div><br></div><div><div dir=3D"ltr" class=3D"gmail_signature=
"><div dir=3D"ltr"><div>Vladimir</div><div><br></div></div></div></div></di=
v></div>

--0000000000003cf14406357ee963--