Re: Binary encoding of TIMESTAMP WITH TIME ZONE

Joe Abbate <jma(at)freedomcircle(dot)com> writes:
> However, when using the same query using the Rust adapter the transition
> to a new row started showing up after midgnight GMT. I opened an issue
> on Github (https://github.com/sfackler/rust-postgres/issues/608 ) and
> the maintainer claimed the Rust adapter *had* to initialize timezone to
> UTC in order to properly convert "to and from time datatypes". I
> pointed out that the timezone offset is available in psql and psycopg2,
> but then he replied the binary encoding of timestamptz does *not*
> include the timezone offset.

Indeed it does not, just as the on-disk format for it does not. The
representation is effectively always in UTC. If you have some other
timezone setting selected, timestamptz_out rotates to that zone for
display purposes ... but the binary format doesn't.

regards, tom lane