You can translate the question and the replies:

SQL Server date datatypes error in conversion for base views

¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. * Source Server DataBase is SQLServer 2016. * SQL Server has Collation `SQL_Latin1_General_CP1_CI_AS` * Conflicting datatypes: datetime2, smalldatetyme ![SQL Server](https://live.staticflickr.com/65535/49994760828_5784714c19.jpg) Here's datatypes in conflict: ![Data Types](https://live.staticflickr.com/65535/49995534062_8b10d48e8a_n.jpg) Denodo VDP version is 7.0, has 20200310 update installed. Also VDP was installed with Internationalization configuration of: `mx` ![VDP_Installation](https://live.staticflickr.com/65535/49994760738_55baf78c71.jpg) Here's the base view: ![BaseView](https://live.staticflickr.com/65535/49994760773_03a105a2df_n.jpg) And the result: ![BaseViewExec](https://live.staticflickr.com/65535/49995534137_01d09fd59e_n.jpg) In base view I've tried every i18n option with no different result. Please provide your help or assitance.
user
11-06-2020 12:01:02 -0400

1 Answer

Hi, There is a same question being raised, and it has been answered here: [SQL Server date conversion error in BaseView](https://community.denodo.com/answers/question/details?questionId=9060g0000004FVVAA2&titleSQL%20Server%20date%20conversion%20error%20in%20BaseView) Hope this helps!
Denodo Team
15-06-2020 04:04:07 -0400
You must sign in to add an answer. If you do not have an account, you can register here