Re: Timestamp Conversion Woes Redux - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Timestamp Conversion Woes Redux
Date
Msg-id B3BA4316-26FB-4C7B-BAE4-AAC2F9B6574C@fastcrypt.com
Whole thread Raw
In response to Re: Timestamp Conversion Woes Redux  (Christian Cryder <c.s.cryder@gmail.com>)
Responses Re: Timestamp Conversion Woes Redux  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
Actually,

Java has timezones that postgres doesn't understand, which is
why using the server timezone makes more sense.

Hopefully java understands all the timezones postgres understands.

Dave
On 20-Jul-05, at 1:47 PM, Christian Cryder wrote:

> On 7/20/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Hmm ... does Java have a standard set of timezone names?  If so,
>> does it
>> bear any resemblance to the zic database names?
>>
>
> Yes, you can see them by running this snippet...
>
> String zones[] = TimeZone.getAvailableIDs();
> for (int i=0; i<zones.length; i++) {
>     System.out.println("   "+i+": "+TimeZone.getTimeZone(zones[i]));
> }
>
> No idea how that compares to zic...
>
> Christian
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>


pgsql-jdbc by date:

Previous
From: Vadim Nasardinov
Date:
Subject: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)
Next
From: Tom Lane
Date:
Subject: Re: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)