Unable to change default Date format in SQL Server Express

• User_from_Europe

  SSC Journeyman

  Points: 80

  More actions

  March 22, 2017 at 2:02 am

  #401823

  I have a problem with changing default Date format. I changed the language to British English on server. I added new user and set British English as default language for him, but date is still showing in format ymd.

  I want all dates in all databases to be in format dmy as default. I have tried this both on SQL Server Express 2014 edition and 2016 edition, but all dates are still in old English format (ymd).

• Thom A

  SSC Guru

  Points: 99137

  More actions

  March 22, 2017 at 3:32 am

  #1934262

  You don't need to change the format of your dates in your SQL, change it in your presentation layer. SQL will always display dates in the format yyyy-MM-dd, as per msdn, it's not relevant to your language settings.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk