ODBC pass a calculated timestamp to DB cause error

From: liu__liu(at)hotmail(dot)com (liu)
To: pgsql-general(at)postgresql(dot)org
Subject: ODBC pass a calculated timestamp to DB cause error
Date: 2002-10-24 23:52:31
Message-ID: 9fe822f7.0210241552.292c4a3a@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Williams, Travis L, NPONS 2002-10-24 23:59:33 Re: A way to link oracle DB to postgres DB for data transfer
Previous Message Zuhra.Sanusi 2002-10-24 23:42:30 A way to link oracle DB to postgres DB for data transfer