Re: Query about time zone patterns in to_char

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-05-16T17:04:15Z
Lists: pgsql-hackers
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



Commits

  1. Support "of", "tzh", and "tzm" format codes.

  2. Implement TZH and TZM timestamp format patterns