Re: [GENERAL] Trouble with timestamp in PQprepare/PQexecPrepared

2010-05-31 Thread Viktor Pavlenko
>>>>> "TL" == Tom Lane writes: TL> Viktor Pavlenko writes: >> I'm using PG 8.1.11 on linux and having trouble inserting a >> timestamp value (for starters :)) from a C++ program. TL> The first argumen

[GENERAL] Trouble with timestamp in PQprepare/PQexecPrepared

2010-05-31 Thread Viktor Pavlenko
Hello, I'm using PG 8.1.11 on linux and having trouble inserting a timestamp value (for starters :)) from a C++ program. The table: CREATE TABLE test_tbl (ts TIMESTAMP (6) NOT NULL); Insert works from psql: INSERT INTO test_tbl VALUES (to_timestamp('20100527101705806216', 'MMDDHHMISSUS'))