duplicating and date problem
Started by Borisabout 24 years ago2 messagesgeneral
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
Re: duplicating and date problem
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