| From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
|---|---|
| To: | Junwang Zhao <zhjwpku(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: jsonpath: Inconsistency of timestamp_tz() Output |
| Date: | 2024-07-10 15:19:32 |
| Message-ID: | 287C2A57-2AD9-4D0D-9452-EDE9CDA8A7E8@justatheory.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Jul 10, 2024, at 10:54, David E. Wheeler <david(at)justatheory(dot)com> wrote:
> So it should be -7, not -8. Not sure where to tell it to pay proper attention to daylight savings time.
Oh, and the time and date were wrong, too, because I blindly used the same conversion for dates as for timestamps. Fixed in v2.
PR: https://github.com/theory/postgres/pull/7
CF: https://commitfest.postgresql.org/49/5119/
Best,
David
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch | application/octet-stream | 4.1 KB |
| unknown_filename | text/plain | 2 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2024-07-10 15:28:49 | Re: Is it possible to create a cursor with hold using extended query protocol |
| Previous Message | Tom Lane | 2024-07-10 15:11:13 | Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal |