Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones - Mailing list pgsql-general

From Lincoln Swaine-Moore
Subject Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Date
Msg-id CABcidk+FSeyoPd4Km0xBPsvDqcXnXGit_mS7UAL9Ujp9k9bKmw@mail.gmail.com
Whole thread Raw
In response to Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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.

I see. You mean, in the event that it doesn't conform to an entry in `pg_timezone_names`? I do have control over the possible options the user can provide, so it should be straightforward to make sure those all have entries.

Thanks,
Lincoln

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Next
From: Tom Lane
Date:
Subject: Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones