Re: Timestamp Conversion Woes Redux

On 20-Jul-05, at 8:16 PM, Oliver Jowett wrote:

> Kris Jurka wrote:
>
>>
>> On Thu, 21 Jul 2005, Oliver Jowett wrote:
>>
>>
>>> Aside from the issues that others have raised, I was worried about
>>> existing code that does *not* use PreparedStatement. (probably
>>> with good
>>> reason given this discussion!)
>>>
>>> I really don't think the driver should be touching TimeZone :/
>>>
>>
>> You might appreciate this archived message...
>>
>> http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00169.php
>>
>
> Heh, good point :-)
>
> Of course there are no broken applications out there! ;-)
>
> I still think touching TimeZone is asking for trouble -- we've got no
> guarantees that the Java and server timezone databases are 100% in
> sync
> (even for those timezones in common)

If we track the server's timezone in the driver, then if we get a
timezone that we don't understand
we can just use the JVM's default time zone.
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>