You are right. PostgreSQL's TIMESTAMP WITH TIME ZONE has "Instant" semantics. That's the reason that CALCITE-1947 change the type as "TIMESTAMP WITH LOCAL TIME ZONE"
*Best Regards,* *Zhenghua Gao* On Thu, Dec 19, 2019 at 4:17 PM Vladimir Sitnikov < [email protected]> wrote: > Zhenghua>the implementation was similar to PostgreSQL's > > PostgreSQL DB stores timestamps similar to "UNIX timestamp" (it uses int8), > and it does that for both "with" and "without" time zone. > In other words, PostgreSQL cannot have "OffsetDateTime" semantics :( > > Vladimir >
