We have a SQL Server 2012 Table with fields of type datetimeoffset(7). We need t

JEAN PIERRE over 10 years ago

We have a SQL Server 2012 Table with fields of type datetimeoffset(7). We need to match this table to a CDT. We tried the Appian datatype datetime but this didnt worked. (error: The data source schema does not match the type mappings: Wrong column type in VCA_BO.dbo.ScvPs for column created. Found: datetimeoffset, expected: datetime (APNX-2-4056-000) ).
What is the correct Appian datatype to match the SQL Server datatype datetimeoffset?...

Discussion posts and replies are publicly visible

Parents

0 JEAN PIERRE over 10 years ago

An error: the server is SQL Server 2008 R2 not SQL Server 2012
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 JEAN PIERRE over 10 years ago

An error: the server is SQL Server 2008 R2 not SQL Server 2012
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data