Re: problem with dates when using a java calendar object with

Hi Markus,

Markus Schaber wrote:

>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.
>
>
My test table definition is: create table date_test (d date)
As you can see it is a date type, so there's no time zone information on it.
Do you think that the date not having time zone information is the
source of the problem? If yes, what time zone should I use so that dates
are correctly inserted and selected? UTC time zone? The default JVM
timezone?

Thanks,
Jair Jr

>HTH,
>Markus
>
>
>
>
>