Member Avatar for stoefln

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??

  • 3 Contributors
  • 3 Replies
  • 212 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by akronymn
Member Avatar for 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

Member Avatar for stoefln

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...

Member Avatar for akronymn

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.