Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lincoln Swaine-Moore <lswainemoore@gmail.com>
Cc: Marian Wendt <marian.wendt@yahoo.com>, pgsql-general@lists.postgresql.org
Date: 2023-10-04T17:22:49Z
Lists: pgsql-general
Lincoln Swaine-Moore <lswainemoore@gmail.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