Обсуждение: duplicating and date problem

Hello pgsql-general,

a) is it possible to duplicate a specific row into another table
(append)?

b) I try to insert a datetime into my table, but I  have error
messages -((

SQL:

insert into xyz (datum) values('2002-02-27 15:47:06+01');

gives me:

Warning: PostgreSQL query failed: ERROR: Bad timestamp external representation ''



--
Best regards,
 Boris

> 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