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

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

From: Vladimir Zolotykh <gsmith(at)eurocom(dot)od(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bad timestamp external representation 'Sun 05 May 11:53:44.731416 2002 EEST'
Date: 2002-05-05 09:03:00
Message-ID: 3CD4F544.E8896166@eurocom.od.ua (view raw or flat)
Thread:
Lists: pgsql-bugs
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:19 2001 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:19 2001 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: line 2952, Bad timestamp external representation 'Mon 26 Mar 18:45:36 2001
EEST'
  psql:copy-command.sql:1: lost synchronization with server, resetting connection
  $ 

Could you suggest something ?

Best regards

-- 
Vladimir Zolotykh

pgsql-bugs by date

Next:From: Mike RogersDate: 2002-05-06 02:08:37
Subject: Large PG_DUMPs going into memory?
Previous:From: Stephen AmadeiDate: 2002-05-05 01:40:42
Subject: Re: Why does Postgres need the /bin/sh?

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