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??
stoefln
0
Newbie Poster
noman78
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
stoefln
0
Newbie 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
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...
akronymn
0
Newbie Poster
How did you set the language of the user? Thanks! -adam
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.