Re: Allowed timezone values - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Allowed timezone values
Date
Msg-id 200510141140.j9EBeR219758@candle.pha.pa.us
Whole thread Raw
In response to Re: Allowed timezone values  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tatsuo Ishii wrote:
> > Also, JST doesn't work anymore, but JST9 does.  JST has no daylight
> > savings time values, so it is a valid timezone setting, while EST is
> > not:
> > 
> >     test=> set timezone = 'JST';
> >     ERROR:  unrecognized time zone name: "JST"
> > 
> >     test=> set timezone = 'JST9';
> >     SET
> 
> Note that JST and JST9 are completely different timezone. I'm not
> sure this is correct or not...
> 
> test=# select '2005-10-14 18:00' at time zone 'JST';
>       timezone       
> ---------------------
>  2005-10-15 08:00:00
> (1 row)
> 
> test=# select '2005-10-14 18:00' at time zone 'JST9';
>       timezone       
> ---------------------
>  2005-10-14 14:00:00
> (1 row)

Oops, yea.  It should be JST-9:
test=> select '2005-10-14 18:00' at time zone 'JST-9';      timezone--------------------- 2005-10-15 07:00:00(1
row)test=>select '2005-10-14 18:00' at time zone 'JST';      timezone--------------------- 2005-10-15 07:00:00(1 row)
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Allowed timezone values
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] [BUGS] BUG #1962: ECPG and VARCHAR