Set Language not working...

[Sivagami]

I changed my session language using
SET LANGUAGE SPANISH
but it does not help retrieving the correct date/time format. The output when I do
select getdate() is 2003-01-06 15:28:18.530.
How do I change this ? Even
SET DATEFORMAT mdy
does not help.

Thanks,
Shiva.

 

[tlbroadbent]

Set Language and Set DATEFORMAT only affect entering of dates not the display of dates. If you want dates to display in a particular format, you'll have to use Convert and choose the appropriate datetime style. See Cast and Convert in SQL BOL. You may also want to review the information on the following page.

http://tlbroadbent.home.attbi.com/sql/ss_datetime.htm

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[Sivagami]

Thanks for the reply Terry.
My SYSMESSAGES table has entries in just 1 language. If I want to have other languages too, would you be knowing where can I get them and does the server need any additional configuration for that ?

Thanks,
Shiva.

 

[tlbroadbent]

Check here:

http://support.microsoft.com/?id=277535

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.