Re: ResultSet.getTimestamp(Calendar) off by one-hour

Roland Roberts <roland@astrofoto.org> writes:
> And here is what is in the database:

>     roland=# select * from mytable;
>      id |       mytime
>     ----+---------------------
>      12 | 2009-03-13 15:00:00
>     (1 row)

Apparently you're using a timestamp WITHOUT time zone column to store
the data.  Not recommended if you are worried about timezone effects,
since by definition the apparent value depends on caller's timezone
context.  Use timestamp WITH time zone and see if it gets better.

            regards, tom lane