What you experience is a potential consequence of not using language independent datetime string. The interpretation is determined by the langiage for the login. So, go find that login in SQL Server and check what language is defined! You can "fix" this by defining the proper language for this login.
Date and Time Conversions Using SQL Server
SQL Server CONVERT() Function
MS SQL. We all know that different countries require different kinds of date formats. Different applications require different date formats. SQL Server database administrators and developers use the function convert in conjunction with other date functions such as datepart , datename , etc. This article illustrates how to create one common function to get most of the formats required by different countries and applications. Let's create the dbo. Please download the code from here.
default date format of sql server 2008 to dd/mm/yyyy
Subtracting from the Style format number will transform dates without century YY. For example Style is with century, Style 3 is without century. The default Style values — Style 0 or , 9 or , 13 or , 20 or , and 21 or — always return the century yyyy format. Oct 23
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you. This provides the current date and time according to the server providing the date and time. To change the format of the date, you convert the requested date to a string and specify the format number corresponding to the format needed.