Re: TIMESTAMP WITHOUT TIME ZONE - Mailing list pgsql-general

From Tom Lane
Subject Re: TIMESTAMP WITHOUT TIME ZONE
Date
Msg-id 27492.1165965921@sss.pgh.pa.us
Whole thread Raw
In response to TIMESTAMP WITHOUT TIME ZONE  ("Randy Shelley" <randy.shelley@gmail.com>)
Responses Re: TIMESTAMP WITHOUT TIME ZONE  (Richard Troy <rtroy@ScienceTools.com>)
List pgsql-general
"Randy Shelley" <randy.shelley@gmail.com> writes:
> The java.sql.Timestamp does not store any timezone info, just nano seconds
> from a date.

One would hope that it's implicitly referenced to GMT, though, not some
free-floating value that means who-knows-what.

I think your fundamental error is in using timestamp without time zone
in the database.  Try with-time-zone if you want consistent results
across clients in different zones.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeremy Harris
Date:
Subject: Re: Postgres friendly RegEx?
Next
From: Tom Lane
Date:
Subject: Re: Statement timeout not working on broken connections with active queries