ODBC pass a calculated timestamp to DB cause error
От
liu__liu@hotmail.com (liu)
Тема
ODBC pass a calculated timestamp to DB cause error
Дата
Msg-id
9fe822f7.0210241552.292c4a3a@posting.google.com
Список
Дерево обсуждения
Re: solved liu__liu@hotmail.com (liu)
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 по дате отправления