topic datetime2 problems in Data Management Questions https://community.esri.com/t5/data-management-questions/datetime2-problems/m-p/296588#M16987 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm attempting to import an XML schema from a File Geodatabase (originally created in 9.3 but upgraded to 10) into a version 10 SDE Geodatabase (SQL Server 2008). The import keeps failing when it encounters DATE fields in a featureclass. The error says "invalid SQL syntax [Microsoft SQL Server Native Client 10.0: Incorrect synatax near 'DATETIME2'.].</SPAN><BR /><BR /><SPAN>Has anyone seen this error before?</SPAN><BR /><BR /><SPAN>Mark</SPAN></BODY></HTML> Mon, 14 Feb 2011 15:12:08 GMT MarkSmith1 2011-02-14T15:12:08Z datetime2 problems https://community.esri.com/t5/data-management-questions/datetime2-problems/m-p/296588#M16987 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm attempting to import an XML schema from a File Geodatabase (originally created in 9.3 but upgraded to 10) into a version 10 SDE Geodatabase (SQL Server 2008). The import keeps failing when it encounters DATE fields in a featureclass. The error says "invalid SQL syntax [Microsoft SQL Server Native Client 10.0: Incorrect synatax near 'DATETIME2'.].</SPAN><BR /><BR /><SPAN>Has anyone seen this error before?</SPAN><BR /><BR /><SPAN>Mark</SPAN></BODY></HTML> Mon, 14 Feb 2011 15:12:08 GMT https://community.esri.com/t5/data-management-questions/datetime2-problems/m-p/296588#M16987 MarkSmith1 2011-02-14T15:12:08Z Re: datetime2 problems https://community.esri.com/t5/data-management-questions/datetime2-problems/m-p/296589#M16988 <HTML><HEAD></HEAD><BODY><SPAN>I found the problem. It had nothing to do with the field type - the problematic field was named "End" which must be a reserved word in SQL. The error message was a little misleading <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Mon, 14 Feb 2011 16:01:54 GMT https://community.esri.com/t5/data-management-questions/datetime2-problems/m-p/296589#M16988 MarkSmith1 2011-02-14T16:01:54Z