Failed to insert Poco::Nullable< Poco::Data::Date> data into MSSQL using ODBC #2808
Description
Code:
Poco::Nullable< Poco::Data::Date> date;
session << "insert into student( birth) values(?)", use(date), now;
Error:
SQLExecute()
Requested SQL statement: insert into student( birth) values(?)
Native SQL statement: insert into student( birth) values(?)
: Connection:NetConn: 041B6E68
Server:Not applicable
===========================
ODBC Diagnostic record #1:
===========================
SQLSTATE = 22018
Native Error Code = 206
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Operand type clash: tinyint is incompatible with date
===========================
ODBC Diagnostic record #2:
===========================
SQLSTATE = 42000
Native Error Code = 8180
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.