Where does SQL Server get the default date format it uses when returning results from:
CAST(LastLogin AS nvarchar(max))
I would like to change this default format. I cannot use CONVERT() because this query is being generated by Entity Framework.
I am getting:
Jun 22 2015 4:02PM
Jul 19 2015 10:02PM
Jan 30 2016 3:45PM
Jan 18 2016 2:56PM
Feb 4 2016 12:27PM
May 7 2015 9:30AM
I have looked at the regional settings on the server and it has not been set to use this date format.
If interested in the EF issue: C# Generic .Contains() method implementing SqlFunctions.StringConvert in Entity Framework