Skip to Content
0
Apr 24, 2017 at 07:15 AM

PCo: using timestamps in an ODBC destination

136 Views Last edit May 03, 2017 at 07:10 AM 2 rev

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

Attachments

pco-odbc.jpg (33.6 kB)
pco-output.jpg (29.3 kB)
pco-mapping.jpg (29.3 kB)