ODBC pass a calculated timestamp to DB cause error - Mailing list pgsql-general

From liu__liu@hotmail.com (liu)
Subject ODBC pass a calculated timestamp to DB cause error
Date
Msg-id 9fe822f7.0210241552.292c4a3a@posting.google.com
Whole thread Raw
List pgsql-general
in VC++, I need to update a timestamp field with a C++ timestamp(the
seconds
after 19700101), my SQL is like
UPDATE my_table SET time_field=timestamp '1970-01-01
00:00:00'+interval '1 seconds' * ?
OR
UPDATE my_table SET time_field=timestamp '1970-01-01
00:00:00'+interval '? seconds'

then pass in the timestamp as integer parameter,
both works when I use constant instead of parameter, but the parameter
is not
working, how can I pass the timestamp in then?

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: supplying password to psql on command line?
Next
From: nuno.barros@fc.ul.pt (Nuno Barros)
Date:
Subject: Binary Large Objects