Unable to use Datetime offset(7) datatype for SQL Server Service
kbt140984
PRODUCTK2 Five 5.0
BASED ONK2 Five 5.0
TAGSService Broker
SQL
Fix Pack
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
When creating an SQL Service Instance based on a SQL database, with a table containing a column of type datetimeoffset(7), the column is not returned in the Service Instance properties.Symptoms
The column of type datetimeoffset(7) is not returned in the SQL Server Service Instance properties.Looking at the example below, you will notice that only id column is returned.