I've defined an ODBC destination as per SAP Help. Table PDCODB contains a field called ITIMESTAMP of type DATETIME2:
In my agent, I have created a notification with an output expression using function DATENOW of type System.DateTime:
I then did the assignment in the destination mapping:
However, all timestamps appear as 01.01.0001 00:00:00 in table PCODB. When I test the message delivery, I can see the correct timestamp (e.g. [CDATA[2017-04-21T14:34:49]]) in the XML message. Yet, it does not get written into table PCODB for some reason.
Are SQL type DATETIME2 and PCo type System.DateTime perhaps compatible? Do I need to do a conversion?
Thanks & regards