PCo: using timestamps in an ODBC destination

[janbuchmann]

Hi there

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
Jan

[janbuchmann]

FYI

This appears to be a problem only when doing 'Test Notification Delivery'. Otherwise the DB record as well as the XML file get created with the correct time stamp.

[janbuchmann]

FYI

This appears to be a problem only when doing 'Test Notification Delivery'. Otherwise the DB record as well as the XML file get created with the correct time stamp.