Categories
entity-framework sql sql-server

SQL Server Date CAST default format

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
etc.

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