Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Swaine-Moore <lswainemoore(at)gmail(dot)com>
Cc: Marian Wendt <marian(dot)wendt(at)yahoo(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Date: 2023-10-04 17:22:49
Message-ID: 2605699.1696440169@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lincoln Swaine-Moore <lswainemoore(at)gmail(dot)com> writes:
> Excellent, thank you. So just to be explicit here, I could either run this
> function, or set/run my query/set back, with the same behavior/safety
> guarantees as if I was using the generate_series function with timezone
> from v16?

Yeah. One thing to keep in mind is that that might have different
behavior in terms of the evaluation of the arguments to the function,
ie which timezone setting is your input parsed according to.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Swaine-Moore 2023-10-04 17:35:51 Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Previous Message Lincoln Swaine-Moore 2023-10-04 17:10:56 Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones