Re: duplicating and date problem

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: bk <koester(at)x-itec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicating and date problem
Date: 2002-03-15 15:53:26
Message-ID: 3C9218F6.881A5BE2@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> insert into xyz (datum) values('2002-02-27 15:47:06+01');
> Warning: PostgreSQL query failed: ERROR: Bad timestamp external representation ''

Works for me:

thomas=# select timestamp '2002-02-27 15:47:06+01';
timestamptz
------------------------
2002-02-27 06:47:06-08

What version are you running?

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-03-15 16:19:47 Re: R: [SQL] UPDATE and SELECT result difference
Previous Message Bruce Momjian 2002-03-15 15:30:28 Re: Archives / News gateway