How can I change SQL language and date format?

1131885 pts.
Tags:
SQL
SQL Server
I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

In order to view all languages try below syntax:

select * from sys.syslanguages

If you need to permanently change the language then

  1. Go to Security option
  2. Then Login with your account
  3. Right Click on your user name and select properties
  4. Change the default language to English 

If you want to change data format to follow these steps:

Set date format to month/day/year.

SET DATEFORMAT mdy;

DECLARE @datevar datetime2 = ’12/5/2016 09:01:01.1234567′;

SELECT @datevar;

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Is this a new installation on another machine? That version is quite old. It may not have the features you want.
    129,440 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: