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  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