Convert date to string yyyy-mm-dd sql server ____________________________________________________________________________________________________ ❤️ Link №1: https://bit.ly/2E7gikG ____________________________________________________________________________________________________ ❤️ Link №2: http://tageperte.fastdownloadcloud.ru/dt?s=YToyOntzOjc6InJlZmVyZXIiO3M6MjQ6Imh0dHA6Ly9zdGlra2VkLmNvbV8yX2R0LyI7czozOiJrZXkiO3M6NDQ6IkNvbnZlcnQgZGF0ZSB0byBzdHJpbmcgeXl5eS1tbS1kZCBzcWwgc2VydmVyIjt9 ____________________________________________________________________________________________________ SELECT EnglishProductName AS ProductName, ListPrice FROM dbo. You can't post new polls. Using CAST and CONVERT with datetime data Starting with GETDATE values, this example displays the current date and time, uses CAST to change the current date and time to a character data type, and then uses CONVERT to display the date and time in the ISO 8601 format. First, find the moron and beat him, and replace all of his code. These are things that the database engine cannot know - and this is why you should generally not do what you are trying to do. Is there a connect item that changes datetime's implicit conversion behavior? SQL Server - Formatting Date/Time - You can't edit your own topics. In my opinion you should re-consider the assumption that the date picker returns a string. Maybe it is able to return a DateTime object directly instead of string. Then you will pass this value as a parameter of SQL query. This should work regardless of computer configuration. Otherwise, follow the previous string-based approaches. My application is developed in WPF. The date I select will be in string format since I am using control wpf datetime edit control of syncfusion. In my opinion you should re-consider the assumption that the date picker returns a string. Maybe it is able to return a DateTime object directly instead of string. Then you will pass this value as a parameter of SQL query. This should work regardless of computer configuration. Otherwise, follow the previous string-based approaches. SELECT EnglishProductName AS ProductName, ListPrice FROM dbo. SELECT EnglishProductName AS ProductName, ListPrice FROM dbo. For every north, there is an equal and opposite expert. It is very unfortunate and in my opinion undesirable that a string like '2013-12-11' does not get converted to 11 December 2013 in all circumstances. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. It will not fail with USA locale, but this is not the point.