| From: | Jan Varga <varga(at)utcru(dot)sk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | CEST timezone |
| Date: | 2001-10-03 08:24:58 |
| Message-ID: | 3BBACB59.483EABEB@utcru.sk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Is it a bug or CEST timezone is not supported anymore ?
I can't import my 7.1.2 database to current development version of
postgresql
lis=# create table test (ts timestamp);
CREATE
lis=# insert into test values ('23.05.2000 09:06:59.00 CEST');
ERROR: Bad timestamp external representation '23.05.2000 09:06:59.00
CEST'
lis=# insert into test values ('23.05.2000 09:06:59.00 CET');
INSERT 125614 1
lis=# select * from test;
ts
--------------------------
23.05.2000 10:06:59 CEST
(1 row)
lis=# select version();
version
----------------------------------------------------------------
PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
lis=#
Jan Varga
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2001-10-03 09:07:07 | Re: btree_gist regression test busted? |
| Previous Message | Zeugswetter Andreas SB SD | 2001-10-03 08:09:46 | Re: Unicode combining characters |