how to set sql server date time format

Question

dear sir,

i have used windows 7 ultimate os.

i have work on siemens wincc explorer scada software.

there i develop the report work based on sql server.

but problem is when i set my system the date format in ddmmyyyy, then my data was not stored in sql server.

but when  

i set my system the date format in yyyymmdd, then my data was stored in sql server.

so how i change the sql server date format.

i attach screen shot (there one red box ,so this date format i required ddmmyyyy)

plz give solution.

Answer 1

Hello Abhijit,

Thank you for visiting Microsoft Community and providing us with the detailed description about the issue.

As per the description, I understand that you are experiencing issue setting SQL server date time format. When you try to set the system date format id ddmmy, then the data is not stored in SQL server on the system.

In order to get more information regarding this issue, we have a dedicated forum where such issues are handled and would be better suited in the TechNet community.

Please visit the link below to find a community that will offer the best support.

https://social.technet.microsoft.com/Search/en-US/Technet?query=SQL%20server&beta=0&ac=4#refinementChanges=129&pageNumber=1&showMore=false

I hope this information is helpful.

Please do let us know if you need any further assistance, we will be glad to assist you.

Thank you.