Past year our old SQL Server (SQL Server 2005) was put on new hardware and was upgraded (SQL Server 2016). After that I have problems with dates when I use ODBC queries to get data from SQL Databases into Excel (yes, it isn't Access, but I think it is more SQL Server problem).
I (and other people here too) use "dd.mm.yyyy" as short date format (determined by Windows Regional settings). ODBC query returns dates in format "yyyy-mm-dd" (US Format, I think), which my Excel recognizes as string, not as date. Obviously in upgraded SQL Server some setting is off compared with old server, as in past same queries returned dates in our format. Can someone advice me, where to look for?
Thanks in advance!