On Thu, Mar 16, 2017 at 4:41 PM, Julian Hyde <[email protected]> wrote: > >> On Mar 16, 2017, at 4:25 PM, Jinfeng Ni <[email protected]> wrote: >> >> Time/Timestamp without t/z should be interpreted as local time. > > > No. > > If I am in pacific time and I have a TIMESTAMP value “1970-01-01 12:00:00” > and I send it to you in central european time you receive a TIMESTAMP value > “1970-01-01 12:00:00”. > > Its time zone is not my local time zone, or your local time zone, or UTC. It > has no time zone. > >
Maybe I did not read the SQL 2011 ISO/IEC 9075-2:2011(E) correctly. How do we interpret the following ? "A datetime value, of data type TIME WITHOUT TIME ZONE or TIMESTAMP WITHOUT TIME ZONE, may represent a local time"
