Hello.I'm struggling on this one.I have an asp.net application that gets date format from sql server 2008.In my local computer and with dateformatstring set to {0:f} i get the correct date.When i deploy it in the 2008rc server that i have then the data shows in English (Thursday, March 29, 2012 2:29 AM).I have used the Greek langugae packs for the server 2008rc and i use collation Greek_CI_AI for the database but i will always be in English language when it's brought from the server.Is this something windows server specific or sql?Should i bring this to some other forum?Thanks.
if datatype is datetime the date values will be stored internally as a number not as a string in any specific format. The date values displayed in application while retrieved from table depends on whats the language regional setting in application and in browsers it will also depends on client machines language settings.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Yes but my server and client both use Greek but when i test it on client(my machine) form Visual Studio it displays Greek and when i test it on client from server it displays English.How can this be?
Does sql interacts with date language format?
Posted - 04/09/2012 : 22:43:01
