Re: problem with dates when using a java calendar object

Hi, Jair,

On Wed, 13 Oct 2004 20:26:09 -0300
Jair da Silva Ferreira Jr <j2(at)amazon(dot)com(dot)br> wrote:

> Hi,
> I am experiencing the following problem with postgresql: the date
> value I insert into the database is different from the value I select
> from the database. I use a Calendar with a non-default timezone to set
> and get the date value (using methods
> PreparedStatement.setDate(int,Date,Calendar) and
> ResultSet.getDate(int,Calendar)).
> Do you know how can I fix this problem? Am I doing anything wrong?

Could you tell us how the table is defined? If you have it defined as
"TIMESTAMP WITHOUT TIME ZONE", your dates always get converted to UTC
and loose the time zone.

HTH,
Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com