I have a table say ABC, in that table i have a field createdDate having datatype date , now i have created an insert proceedure for this table and in createdDate field i created a parameter like this :
@createdDate nvarchar(50)
then when calling this proceedure in c# , i do this :
cmd.Parameters.AddWithValue("@createdDate",DateTime.Now.ToShortDateString());
when record is inserted it shows date like this :
2014-08-23
will doing these steps be harmful for me in future ? while using SSRS , or when getting data to gridview ... e.t.c ??