Re: do I correctly understand these date/time data types?

2018-06-24 Thread Bruce Momjian
On Sun, Jun 24, 2018 at 05:13:38PM -0400, Chapman Flack wrote: > Checking my understanding as in $subject: > > A TIMESTAMP WITH TIME ZONE has had its specified time zone used at the point > of entry to convert it to Z time, and then discarded. If I have to map one > of these to a

do I correctly understand these date/time data types?

2018-06-24 Thread Chapman Flack
Checking my understanding as in $subject: A TIMESTAMP WITH TIME ZONE has had its specified time zone used at the point of entry to convert it to Z time, and then discarded. If I have to map one of these to a date/time-with-time-zone datatype in another language, I may as well unconditionally map