CODEWITHSUNDEEP
sqlsql-serverms-access
jedu
jedu

Reputation: 1341

How to set SQL date time format to mm/dd/yy with no time in linked tables?

I linked my Access table to SQL Server backend. During the conversion the date time format got changed to SQL date time format. Now instead of showing date as mm/dd/yy , the linked table is showing date and time as YEAR-MONTH-DAY 00:00:00.0000000 which is coming from the SQL server datetime datatype.

How to I change the format of the data type back to simple mm/dd/yy without any time showing?

Upvotes: 1

Views: 809

Answers (1)

jedu
jedu

Reputation: 1341

So I used SQL Server Migration Assistant to link tables. From SQL Server Docs they want us to use datatime2 instead of datetime datatype. For this reason i guess while automatic conversion they changed the datatype to datetime2. All I had to do was go to SQL server change the datatype to datetime and refresh table link in my linked table. Access then assumes than uses the date/time datatype to display the date front end and ignores the time automatically. You guys were right about this

Dates/times have no inherent format, it's only how they are displayed in a client app that changes

Upvotes: 2

Related Questions