Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicating and date problem - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: duplicating and date problem
Date
Msg-id 3C9218F6.881A5BE2@fourpalms.org
Whole thread Raw
In response to duplicating and date problem  (Boris Köster <koester@x-itec.de>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Archives / News gateway
Next
From: Dmitry Tkach
Date:
Subject: Re: Drop all databases objects except the database