Juraj Duráni created TEIID-4605: ----------------------------------- Summary: SqlServer translator - insert/update statements - timestamp is cast to datetime Key: TEIID-4605 URL: https://issues.jboss.org/browse/TEIID-4605 Project: Teiid Issue Type: Bug Affects Versions: 8.12.5 Reporter: Juraj Duráni Assignee: Steven Hawkins For update statements (insert, update), *timestamp* values are cast to *datatime* type. In MSSQL, this type's range start from year 1753 (1753\-01\-01...). However, there is *datetime2* type, which start from 0001\-01\-01. This default cast to *datetime* prevents user from inserting value before year 1753 even if column in MSSQL is defined as datetime2. Note: Specifying column option NATIVE_TYPE has no effect on this issue. -- This message was sent by Atlassian JIRA (v7.2.3#72005)