Thread: Bad timestamp external representation 'Sun 05 May 11:53:44.731416 2002 EEST'

Bad timestamp external representation 'Sun 05 May 11:53:44.731416 2002 EEST'

From
Vladimir Zolotykh
Date:
Hi

I found a strange error (at least at first glance I had thought it
seems so):

mail=# select * from accounts_log where login='trading'; id  |  login  | debet |  credit   |             when
 
 
------+---------+-------+-----------+------------------------------6289 | trading |  1170 | 1294.9071 | Wed 21 Mar
18:07:192001 EET
 
(1 row)

mail=# select * from accounts_log where login='trading' and "when" = '2001-03-21 18:07:19'; id  |  login  | debet |
credit  |             when             
 
------+---------+-------+-----------+------------------------------6289 | trading |  1170 | 1294.9071 | Wed 21 Mar
18:07:192001 EET
 
(1 row)

mail=# select * from accounts_log where login='trading' and "when" >= '2001-03-21 18:07:19';
ERROR:  Bad timestamp external representation 'Wed 04 Apr 20:00:56 2001 EEST'
mail=# 

Could you add some comments to this ?

Also I'd like to question if you don't mind: While now() outputs
 Sun 05 May 11:53:44.731416 2002 EEST

It seems I can't use EEST (Eastern Europe Summer Time) in input:
 proba=# select * from temp;  n | date  ---+------ (0 rows)
 proba=# \d temp       Table "temp"  Column |           Type           | Modifiers
--------+--------------------------+----------- n      | integer                  |   date   | timestamp with time zone
|
 
 proba=# select * from temp where date = 'Sun 05 May 11:53:44.731416 2002 EEST'; ERROR:  Bad timestamp external
representation'Sun 05 May 11:53:44.731416 2002 EEST' proba=# 
 

The EETDST time zone abbreviation works but it is inconvenient because
all files produced with pg_dump utility or copy command contains EEST
and I can't use then without some modifications e.g
 $ psql -e -f copy-command.sql proba Using pager is off. COPY "temp" FROM stdin; psql:copy-command.sql:1: ERROR:  copy:
line2952, Bad timestamp external representation 'Mon 26 Mar 18:45:36 2001
 
EEST' psql:copy-command.sql:1: lost synchronization with server, resetting connection $ 

To be precise, DST time was started at 25 Mar 2001 at 01:00 UTC for
our time zone (UTC+2) if it does matter.

Could you suggest something ?

Using PostgreSQL 7.2 on Slackware 8.0


Best regards

-- 
Vladimir Zolotykh