Re: TIMESTAMP WITHOUT TIME ZONE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Randy Shelley" <randy(dot)shelley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TIMESTAMP WITHOUT TIME ZONE
Date: 2006-12-12 23:25:21
Message-ID: 27492.1165965921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Randy Shelley" <randy(dot)shelley(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-12 23:30:44 Re: Statement timeout not working on broken connections with active queries
Previous Message Tom Lane 2006-12-12 23:15:55 Re: indexed function performance