public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: pg_timezone_names
Date: Wed, 17 Jan 2018 12:33:29 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

=?utf-8?q?PG_Doc_comments_form?= <[email protected]> writes:
> We are exporting data from postgres into another "all in one" data store,
> and i had a quick question regarding the time offsets.  The UTC_OFFSET, does
> it change when IS_DST is true/false?

Yes; utc_offset reflects the zone's current offset from UTC, so it changes
with the seasons if the zone has DST laws.

> Or do I need to take the UTC_OFFSET
> interval and then possibly add 1 more if IS_DST is true?

Prepare to be disappointed; you can't assume it works like that.
See the thread starting here:

http://mm.icann.org/pipermail/tz/2017-December/025682.html

You haven't said what it is you are hoping to accomplish, so it's
hard to say if there's some safer way to do it.

			regards, tom lane

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_timezone_names
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox