title: SQL Server Steps For Changing US Date to UK Date (ymd to dmy)
body: <p>Can anyone help me what steps should I take to have my SQL Server show date query as <code>dd-mm-yyyy</code>?</p>
  
  <p>Right now clicking on table select top 1000 rows it will show the dates as <code>yyyy-mm-dd 2013-01-01</code> my sql server set as English. Should I change the Server default Language to British English? I have changed the server + the user to British English but when I execute sql query </p>
  
  <pre><code>SELECT TOP 1000 [id_objednavk]
        ,[datumprevzeti_objednavk]
        ,[id_prod]
        ,[mnozstvi_objednavk]
        ,[stavzbozi_objednavk]
    FROM [DAR].[dbo].[Objednavky_dodavat]
  </code></pre>
  
  <p>The date is shown as <code>2013-01-01</code></p>
  
  <p>Can anyone help?</p>