Re: Query about time zone patterns in to_char

> Hm.  If Oracle does that, then there's an argument for us doing it
> too.  I can't get hugely excited about it, but maybe someone else
> cares enough to prepare a patch.

Thanks for the confirmation. Attached patch supports these format
patterns. Kindly review and let me know if any changes are required.

Thanks & Regards,
Nitin Jadhav
On Sun, May 16, 2021 at 10:34 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Nitin Jadhav <nitinjadhavpostgres@gmail.com> writes:
> > Thanks for the explanation. I also feel that we may not support every
> > case-variant. But the other reason which triggered me to think in the
> > other way is, as mentioned in commit [1] where this feature was added,
> > says that these format patterns are compatible with Oracle. Whereas
> > Oracle supports both upper case and lower case patterns. I just wanted
> > to get it confirmed with this point before concluding.
>
> Hm.  If Oracle does that, then there's an argument for us doing it
> too.  I can't get hugely excited about it, but maybe someone else
> cares enough to prepare a patch.
>
>                         regards, tom lane