DaniWeb IT Discussion Community - datetime format in ms sql

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- MS SQL (http://www.daniweb.com/forums/forum127.html)

- - datetime format in ms sql (http://www.daniweb.com/forums/thread36058.html)

stoefln

Nov 29th, 2005 4:43 am

datetime format in ms sql

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

noman78

Nov 30th, 2005 7:31 am

Re: datetime format in ms sql

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

Nov 30th, 2005 10:06 am

Re: datetime format in ms sql

Quote:

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

All times are GMT -4. The time now is 2:21 am.