Please support our MS SQL advertiser: Programming Forums
Views: 36405 | 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: 4
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)
Linear Mode
