sql user default language problem

[baran121]

Hi Everybody,
i have installed SQL server 2016 standart edition running on Windows 2019.
I create an user i tried to use Default language as English. but each time i set it English then when i want to look back language goes back to Arabic.

my main problem when i use
print getdate()
i have 12 Hours with AM-PM, but i want to use 24 Hours timing.

can you help me please,I got crazy,and couldnt understand what is problem.
Thank you.

 

[johnherman]

These questions might be better asked in the Microsoft SQL Server: Setup and Administration forum.

https://www.tek-tips.com/threadminder.cfm?pid=962

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[gmmastros]

What are you doing to set the default language for the users?


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[baran121]

what you mean gmmastros about doing. sorry i didnt understand.
i just wanted to use dateformat dd.mm.yyyy and time format hh:mm (24 hours)
and i wanted to understand why i couldnt change any user's language from arabic in security part.
thanks.

 

[gmmastros]

Date formats can be confusing. If you simply select a date and/or time, you will see SQL Server's representation of it, which is yyyy-mm-dd hh:mm:ss.nnn

A login's default language only applies to converting to date.

Ex:

-- This will use the login's dateformat for their default language
Select Convert(DateTime, '09.10.2019')

-- you can override the default language like this.
set language German
Select Convert(DateTime, '09.10.2019')
set language us_english
Select Convert(DateTime, '09.10.2019')

Note that for German, a date in October is returned, but for US English, the date is in September.

When converting FROM datetime to string, you can use the convert function with the optional 3rd parameter for style, like this:

Select Convert(VarChar(20), GetDate(), 104)
Select Convert(VarChar(20), GetDate(), 108)

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[baran121]

Hi gmmastros,
Thank you for your reply.
I have tried (set language) . But still i have problem.
I susspect Windows server date and time format . Even i change region format with dd.mm.yyyy in my code it gives me in mm.dd.yyyy format.
please help me, thank you.

 

[bborissov]

Handle how date/datetime will be displayed are job for your frontend.


Borislav Borissov
VFP9 SP2, SQL Server

 

[gmmastros]

Can you show some code that you are having a problem with?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom