Date data type changes to v_string when connected via in-db (SQL server)

[akasubi]

I'm connecting to a date table in SQL server via the connect in-db tool, but when I do this, the date column comes out as a v_string even though the data type in SQL server is date.

Anyone why and how to fix this so that it's still read as a date?

[cplewis90]

Hello @akasubi,

Have you tried a CAST statement on your date field in the In-DB input?

[akasubi · Accepted solution]

Hi @cplewis90 - I did, but it didn't work.

Actually found out that the issue was down to the OLE DB provider that I'd set it up with. Initially I used 'Microsoft OLE DB Provider for SQL Server', but actually I should've been using the 'SQL Server Native Client'.

When I changed this, the data type came through as date.

More info in this link - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-datatype-change/td-p/56361