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

As Kris already pointed out you can use the calendar specified by the
user now; if you download the development driver.

Dave

Jair da Silva Ferreira Jr wrote:

> Hi Markus,
>    Thank you very much for your reply.
>
> Markus Schaber wrote:
>
>> Hi, Jair,
>>
>> On Thu, 14 Oct 2004 11:41:21 -0300
>> Jair da Silva Ferreira Jr <j2@amazon.com.br> wrote:
>>
>>
>>
>>> 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?
>>>
>>
>>
>> It is possible that this is the source of your problem.
>>
>> Table columns with time zone always remember the time zone of the dates
>> stored, while the table columns without time zone convert your date to
>> UTC and forget the original time zone.
>>
>> This had to be changed at postgres level. Just test whether manually
>> inserting dates (e. G. via psql) and then re-reading works.
>>
>>
>    I inserted dates via pgsql and selected them via Java and the
> problem remains. I keep getting wrong days in my date. I think the
> JDBC driver is somehow considering the current jvm timezone to
> calculate dates. I think this is wrong because I am providing a
> user-defined Calendar exactly not to use the jvm default.
>    I analysed the AbstractJdbc2Statement.java and
> AbstractJdbc2ResultSet.java source code and I noticed that the driver
> transforms the date in a String and them inserts it into the database.
> Maybe the problem is how the String is being generated. I think the
> best solution is to use a java.text.DateFormat object with the
> calendar specified by the user set on it. This DateFormat object could
> be used to both insert and select the date value from the database
> because it has a format(Date) and parse(Date) method. What do you think?
>
> Thanks,
>    Jair Jr
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>

--
Dave Cramer
www.postgresintl.com
519 939 0336
ICQ#14675561