I connect to an MS SQL server database where I only have read rights. Inside the database there is a point feature class that has several date fields. The sql server management studio shows that the date fields are (date, null). I can see all the date fields in ArcGIS Pro 2.8.3 but not in ArcMap 10.7.1. The documentation both of ArcGIS pro and ArcMap says that they can read the same types of date field which is datetime2(n), datetime, smalldatetime. Why are the fields visible in ArcGIS Pro then? Am I missing something on the way?
What version of SQL?
Microsoft SQL Azure (RTM) - 12.0.2000.8
Do you have all the RDBMS clients installed for this version of SQL and Desktop? Also, was the feature class created using ArcGIS Pro or desktop?