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>
 <CAB=Je-EmfXoyBRm2LefkxugqNGPta7vf=Ky8ycYpkd02_-WX_w@mail.gmail.com>
In-Reply-To: 
 <CAB=Je-EmfXoyBRm2LefkxugqNGPta7vf=Ky8ycYpkd02_-WX_w@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Mon, 19 May 2025 13:25:54 -0400
Message-ID: 
 <CADK3HHJCnx6Y7Dijmu+XkAqATmYGnGNuvLsc3i5BxsUzZjVX_Q@mail.gmail.com>
Subject: Re: Understanding DateStyle guc in startup packet
To: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Cc: Manav Kumar <mkumar@yugabyte.com>, pgsql-jdbc@lists.postgresql.org,
	Laurenz Albe <laurenz.albe@cybertec.at>
Content-Type: multipart/alternative; boundary="000000000000a6a9ea0635806d68"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHJCnx6Y7Dijmu%2BXkAqATmYGnGNuvLsc3i5BxsUzZjVX_Q%40mail.gmail.com>
Precedence: bulk

--000000000000a6a9ea0635806d68
Content-Type: text/plain; charset="UTF-8"

On Mon, 19 May 2025 at 11:43, Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
wrote:

> >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.
>

If the JDK supports all the variants then yes we could easily accomplish
this.

Dave

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><br></div><br><div class=
=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr=
">On Mon, 19 May 2025 at 11:43, Vladimir Sitnikov &lt;<a href=3D"mailto:sit=
nikov.vladimir@gmail.com">sitnikov.vladimir@gmail.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><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 difference if the app use=
s things like select &#39;03-05-2025&#39;::date.<br><br></div><div>Of cours=
e, it would be great if the app code could resist from casting text to date=
s, however,</div><div>I think the driver should stand in the way there by e=
nforcing a very specific DateStyle value.</div><div><br></div><div>To me, D=
ateStyle looks like timezone, and=C2=A0client_encoding which we currently e=
nforce, yet we could do better and skip enforcing the values.</div></div></=
div></blockquote><div><br></div><div>If the JDK supports all the variants t=
hen yes we could easily accomplish this.</div><div><br></div><div>Dave</div=
></div></div>

--000000000000a6a9ea0635806d68--