Is it possible in the MSSQL server to change the date format from the year-month number to the number-month-year?
  • What do you think there is a format ?? IMHO: The date does not have a format - the date is just a date ... But there are representations, for example, in the form of a string of format DD / MM / YYYY and etc. - timka_s

3 answers 3

The date display for the client is determined by the language the client is connected to. those. when the client performs the connection is checked 1) the default language for the client. You can see either stupidly in the manager, or by sp_helplogins procedure. You can install it either in the manager or via ALTER LOGIN 2) if the language for the client is not installed, the default language set on the server is selected. You can look through sp_reconfigure or through the manager

  • It works ... Thank you))) - Rakzin Roman
  • Although the manager writes the year at first vseravno ..... but this is not so important, the main thing, when I write in the request, he perceives "my" format - Rakzin Roman

For example,

 select convert(varchar(10), GETDATE(), 105)
  • I wrote the select convert (varchar (10), GETDATE (), 105) language set by the British (Set language British) read that the settings affect the restarted server ..... Does not work (((( Rakzin Roman
  • SET DATEFORMAT dmy; GO also set ..... Kapets .... What's the matter? The problem is that there is no wish to write a translation into this dibilny display format in the client program, and there it will be entered everywhere in the form of day-month-year - Rakzin Roman

Yes, the presentation of the date can be changed, I somehow dealt with this a long time ago, dig in the direction of SET DATEFORMAT . Docks

  • msi was right, so SELECT CONVERT (nvarchar (30), GETDATE (), 105) get the answer 30-01-2012 in 2008R2 - Nikita Sistemny