Post reply

Unable to change default Date format in SQL Server Express

  • 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).

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply