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 по дате отправления
От: Andrew Sullivan
Дата:
От: nuno.barros@fc.ul.pt (Nuno Barros)
Дата:
Сообщение: Binary Large Objects
FAQ