Resolve treatment of few date and time datatype as string in Sagent

Product Feature: Design Studio
Database: SQL Server 2008
 

Issue

While using the SQL Server 2008, date, time and datetime2 data types are treated as string in Sagent baseview. This behavior is not observed for 'datetime' datatype only.

Cause

'date', 'time' and 'datetime2' data type are not supported in Sagent with baseview created on SQL Server 2008.

Resolution

UPDATED: August 31, 2017
If required, this can be raised as an Enhancement request through the portal.