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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-04 : 07:21:42
|
| Anyz writes "Hi,I need your help regarding localization including currency settings, date formates.Using SQL Server 2k we can insert values for money type with any supported currency symbols no matter what the Windows regional settigns is. How can we restrict to allow only currency symbols according to regional settings? Also how can we display currency symbol what was inserted as it is not stored in db?How to get formated dates according to regional settings?In short what effects regional settings on various aspects of data in sql server? Thanks in advance for your time.Anyz" |
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-02-10 : 10:15:05
|
| I'm having the same trouble. I want to localise the date settings to UK.I have change the regional settings etc. But it still won't accept dd/MMMM/yyyy instead of MMMM/dd/yyyyyDid you find your answer?bazz |
 |
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-02-10 : 11:34:10
|
| Found the answer.The Logins under the security section were set to english. You have to set them to British English.Sorry microsoft i just assumed the english language was created in ENGLAND and not america.silly mebazz |
|
|
|
|
|
|
Localization (Currencey Symbols,Date Formats)