I have a table with a column of type nvarchar , and I pass the following parameter to the stored procedure :
cmd.Parameters.Add("@PointDate", SqlDbType.NVarChar).Value = DateTime.Now;
As expected, I'm getting the following error:
Additional information: Error converting data type nvarchar to datetime.
How do I convert DateTime to nvarchar ?
Good. it all depends on how you are going to use that date as String in your SP.
Converting a date via ToString will generate a string in the general format of the long date whose final result varies according to the language settings of the machine where the function is rotated (unless the application manually changes the culture OR you use one of the ToString overloads to specify another format). This can be problematic.
First of all, you need to figure out what format this SP expects from that String.
1) If it will use the value to compare directly with a SQL datetime, then you will have problems. It would be best to instantiate a SqlDateTime passing as parameter to its date, and then pass as parameter to SP the return of the ToSqlString () function;
var sqlDate = new SqlDateTime(DateTime.Now);
cmd.Parameters.Add("@PointDate", SqlDbType.NVarChar).Value = sqlDate.ToSqlString();
2) If it expects the date in a specific format (dd / MM / yyyy, or yyyy-mm-dd, etc.) then it is best to pass a ToString (string format) to the required format. More information on DateTime formats on MSDN .