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 |
|
suresh_dotnet
Starting Member
6 Posts |
 Posted - 2009-02-11 : 09:34:02
|
| Dear Friends:I have a task on SQL Server 2005 that need to get relative Date format for choosing Language in Regional and Language Option on Control panel.Ex : Default Language setting is "English (United States").So that SQL Query to Get Date has to show " 2/11/2009".Similarly if I select English(United Kingdom) in Regional and Language Option on Control panel.then SQL Query to Get Date has to show the Date format as "11/02/2009".Can any one help on this regard.Thanks suresh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-11 : 09:40:13
|
| didnt understand what you're asking for. do you mean changing date format based on your language settings of client machine? |
 |
|
|
|
|
|
Regional and Language Option settings for SQL Ser