Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2012-04-09 : 22:43:01
|
| 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-10 : 16:38:21
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2012-04-10 : 20:31:53
|
| 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? |
|
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2012-04-10 : 21:42:50
|
| Got it!You must use IIS asp.net globalization settings. |
|
|
|
|
|
|
Does sql interacts with date language format?