< class="prominent-subhead ">

Code Fix: Unable to use the datetimeoffset(7) SQL data type

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 Description

When creating a 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.


  1. Ensure you have K2 Five RTM installed.
  2. Get the K2 Five RTM FP10 from Regional Support.
  3. Install the K2 Five RTM FP10 to apply the fix.
  4. Refresh the SQL Server Service instance.