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

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?...

OriginalPostID-124253

OriginalPostID-124253

Parents
  • Please see the below XSD element


    <xsd:element name="datetm" nillable="true" type="xsd:date">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
    @Column( name="datetm",columnDefinition="datetimeoffset(7)",nullable=true)
    </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>
Reply
  • Please see the below XSD element


    <xsd:element name="datetm" nillable="true" type="xsd:date">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
    @Column( name="datetm",columnDefinition="datetimeoffset(7)",nullable=true)
    </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>
Children
No Data

 Discussion posts and replies are publicly visible