Re: Understanding DateStyle guc in startup packet

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