Set Locale of a SQL Server 2005

By default the SQL Server comes with the Langauge set to “English (United States)”, setting the date format to mm/dd/yy instead of the date format I want it in, which is Australian and has a date format such as dd/mm/yy.

Is there an option in the Server Management Studio / Configuration tools where I can set the locale of the SQL Server, which will prevent the DateTime fields from being formatted in US date format?

  • Generating next sequence number in sql server
  • Is there a tool for refactoring SQL, a bit like a ReSharper for SQL
  • SQL: Using an INSERT within a SELECT statement
  • Search for multiple values in xml column in SQL
  • How can I practice my SQL Server, Sybase, and Oracle skills on a linux box?
  • SQL Server stored procedure looping through a comma delimited cell
  • If not, how can I convert it when I am using a SQL query such as (forgive me if there is incorrect syntax, I made it up on the spot):

    Dim dc As New SqlCommand("INSERT INTO hello VALUES (@Date)", cn)
    dc.Parameters.Add(New SqlParameter("Date", System.DateTime.Now))

    Many thanks in advance. 🙂

  • mysql_real_escape_string() in .NET Framework
  • Getting “Subquery returned more than 1 value error message ” while using Case statement inside Where Not In
  • how to retrieve all data from joining table using parent key
  • How can I show all time between 2 different time parameter
  • T-SQL - Is there a (free) way to compare data in two tables?
  • Get Min In time and Max out TIme. Fom Attendance record in Sql Server
  • 2 Solutions collect form web for “Set Locale of a SQL Server 2005”

    You can set the default language/locale of each user from SQL Management Studio (look under the Security folder).

    And override this for a specific connection using the SET LANGUAGE command (or SET DATEFORMAT if you just want to change the date format).

    You can also set the default language (used for new users) in SQL Management Studio: right-click on the server, select Properties/Advanced/Default Language.

    have no idea what is the format in “down under”

    dd/mm/yyyy hh:mm:ss ?

    if yes, that date is the British/French annotation, so all you need to do is:

    INSERT INTO hello VALUES convert(datetime, @Date + ' 00:00:00', 103)


    INSERT INTO hello VALUES convert(datetime, @Date, 103)

    if you actually place the time

    for more info, check Books online on MSDN to get the correct Code number.

    even in Selects I always use this, no matter what’s in SQL (cause I tend to use Hosting SQL and there I can’t change the formats), like:

    SELECT myColumn FROM myTable WHERE myDateField >= convert(datetime, @Date + '00:00:00', 103)

    hope it helps

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.