On 2020-06-04 20:32:51 -0400, Tom Lane wrote: > Joe Abbate <[email protected]> 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.
However, the explanation still sounds off. I'm not familiar with Rust,
but I wouild expect the Rust time type to be based on Unix time_t or
some variant of it (maybe milliseconds as in Java, or nanoseconds or a
different epoch). That also doesn't include a timezone, so conversion
should be straightforward and not require any timezone to be involved.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
