Re: Query about time zone patterns in to_char
От
Bruce Momjian
Тема
Re: Query about time zone patterns in to_char
Дата
Msg-id
20210520182515.GA8971@momjian.us
Ответ на
Re: Query about time zone patterns in to_char (Nitin Jadhav)
Список
Дерево обсуждения
Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: Query about time zone patterns in to_char Tom Lane <tgl@sss.pgh.pa.us>
Re: Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: Query about time zone patterns in to_char Tom Lane <tgl@sss.pgh.pa.us>
Re: Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: Query about time zone patterns in to_char David Rowley <dgrowleyml@gmail.com>
Re: Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: Query about time zone patterns in to_char Suraj Kharage <suraj.kharage@enterprisedb.com>
Re: Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
Re: Query about time zone patterns in to_char Bruce Momjian <bruce@momjian.us>
Re: Query about time zone patterns in to_char Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Query about time zone patterns in to_char David Zhang <david.zhang@highgo.ca>
Re: Query about time zone patterns in to_char Robert Haas <robertmhaas@gmail.com>
Re: Query about time zone patterns in to_char Nitin Jadhav <nitinjadhavpostgres@gmail.com>
On Thu, May 20, 2021 at 12:21:12PM +0530, Nitin Jadhav wrote: > Thanks Suraj for reviewing the patch. > > > 1: > > +RESET timezone; > > + > > + > > CREATE TABLE TIMESTAMPTZ_TST (a int , b timestamptz); > > > > Extra line. > > > > 2: > > +SET timezone = '00:00'; > > +SELECT to_char(now(), 'of') as "Of", to_char(now(), 'tzh:tzm') as "tzh:tzm"; > > I have fixed these comments. > > > I am not sure whether we should backport this or not but I don't see any > issues with back-patching. Only significant fixes are backpatched, not features. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
В списке pgsql-hackers по дате отправления