Skip site navigation (1) Skip section navigation (2)

Re: Timestamp Conversion Woes Redux

From: Dave Cramer <davec(at)fastcrypt(dot)com>
To: Christian Cryder <c(dot)s(dot)cryder(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kris Jurka <books(at)ejurka(dot)com>,Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Timestamp Conversion Woes Redux
Date: 2005-07-20 18:13:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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.

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

> On 7/20/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to


pgsql-jdbc by date

Next:From: Vadim NasardinovDate: 2005-07-20 18:16:37
Subject: Java's set of timezone names (was: Re: Timestamp Conversion Woes Redux)
Previous:From: Dave CramerDate: 2005-07-20 17:50:31
Subject: Re: Timestamp Conversion Woes Redux

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group