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
-
Support "of", "tzh", and "tzm" format codes.
- 9dde82899cdf 15.0 landed
-
Implement TZH and TZM timestamp format patterns
- 11b623dd0a2c 11.0 cited