•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 392,064 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,252 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 31512 | Replies: 2
 |
| |
•
•
Join Date: Nov 2005
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
anyone has an idea where i can setup the language (the dateformat) for my ms sql database??
Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas??
Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas??
•
•
Join Date: Nov 2005
Location: Dubai,UAE
Posts: 36
Reputation:
Rep Power: 3
Solved Threads: 0
Light Poster
SQL take the datesettings from the windows, the default settings for SQL is american settings with MM/DD/YYYY
so in the control pannel in the regional settings u ahve to cahnge it to wht u want
so in the control pannel in the regional settings u ahve to cahnge it to wht u want
•
•
Join Date: Nov 2005
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by noman78
SQL take the datesettings from the windows, the default settings for SQL is american settings with MM/DD/YYYY
so in the control pannel in the regional settings u ahve to cahnge it to wht u want
dont think you are right- tried it again, and now it works: you can setup the language of the user which connects to the DB, so that datetime is excepted in the language you have set up.
tried your approach too, but that changed nothing at all...
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Hybrid Mode
- How to split datetime format? (ASP.NET)
- Addition 2 column in sql (MS SQL)
- datetime format (MS SQL)
- Want Date Format in dd/mm/yyyy in ASP.Net With C#. (C#)
- need urgent help for a query (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: new in sql world
- Next Thread: Default value of a column
