Hi, I used SSMA to migrate my access back end into SQL server and i linked tables from SQL to my access front end.
All my columns from access tables with data type date() now are datetime2.
I changed all datetime2 in date so now i have something like 2018-07-04. How can i change style of date to look like 04.07.2018 ( i saw that style is 104 - german here https://www.w3schools.com/sql/func_sqlserver_convert.asp) ?
There is any way to change that style automatically in sql server regional or something?
Thank you in advance!
All my columns from access tables with data type date() now are datetime2.
I changed all datetime2 in date so now i have something like 2018-07-04. How can i change style of date to look like 04.07.2018 ( i saw that style is 104 - german here https://www.w3schools.com/sql/func_sqlserver_convert.asp) ?
There is any way to change that style automatically in sql server regional or something?
Thank you in advance!