I'm using SSMS 2016. I have a long date in a file that I want to convert to a shorter date during data conversion. Some of the records are correct and some are not.
convert(varchar,c.Date_Established,20) as OpenedDate,
Results are mixed:
2010-09-15 00:00:00.0000000 did not convert
2013-10-18 00:00:00 did convert
Any help would be appreciated.