Error converting data type nvarchar to datetime SQL Server

Question

I encountered this error:

Error converting data type nvarchar to datetime

When inputting a date in the format of 26/01/2017 as a string literal. I'm inserting using this code in SQL Server: 

CONVERT(DATETIME, @PaymentDate, 104)

Can someone please help me with this?

Answer 1

Your inquiry is also marked with the c# keyword, I see. Don't pass dates as strings if you are passing dates from C# to a SQL server. Send them as a DateTime. The SQL Server DateTime and the.Net DateTime are the same.
By doing this, you can avoid dealing with the display format entirely because neither c# nor SQL Server store the display format in DateTime.

If you actually need to transform the string "26/01/2017" to date, as mentioned in another response, you should use the style option 103.