Date output format in SSMS 2014 AND 2017 as Oct 26 2018

Hello,

I have two identical queries, that I've executed against a SQL Server 2014 server, and another against SQL Server 2017. One of the date columns is returning in the query result window in the format of Oct 26 2018 on the 2014 server. On the 2017 server, it is returning in the more familiar format of 2018-10-26. Since it is occurring on only one of the database that I can tell, I assume this is database setting, but I'm unable to find out where this difference is being driven from.

Thank you.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Nov 07, 2018 at 07:18 PM

Is the date column returning data from a table, or from a function (like getdate()) - in other words can you be sure that the outputs are comparable?
And are you using the same SSMS?

0 ·

tstrole commented · Nov 07, 2018 at 08:05 PM

The data is from a view , based on a linked server query. The same SSMS version is being used. The only variable is that one SQL Instance is SQL 2017, while the other instance is SQL 2014. I tried SSMS 2014 and SSMS 2017.

0 ·