Passing C# DateTime to SQL Server stored procedure as DateTime parameter

Question

I am passing {4/1/2017 12:00:00 AM} from my C# code to SQL Server as a parameter of a stored procedure. And in the stored procedure, I want to convert this into MMddyyyy format for data processing. I tried many suggestions from Google but nothing works for me.

Throwing this error:

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

How you are passing the values from c#, is it possible to include the code?' — sujith karivelil, Apr 28 '17 at 07:44
First of all, why do you `want to convert to MMddyyyy in SQL for data processing?` Can't you compare DateTime with another DateTime? — Nikhil Agrawal, Apr 28 '17 at 07:46
@Un - lucky -- Please find the code objSqlParameter[1] = new SqlParameter("@Startdate", Startdate) — Tech Learner, Apr 28 '17 at 07:47
@Nikhil -- There is a requirement to store that date in two tables. One table has DateTime datatype and another has varchar datatype. — Tech Learner, Apr 28 '17 at 07:49
Best case would be to change the varchar one to DateTime then. Will save a lot of work for you. — Nikhil Agrawal, Apr 28 '17 at 07:50
@Nikhil -- I can't change existing table schema since that is used by many. — Tech Learner, Apr 28 '17 at 07:51

score 0 · Answer 1 · answered Apr 28 '17 at 07:45

0

Try Convert keyword in SQL but should pass some param value (101,107) for convert.

answered Apr 28 '17 at 07:45

Tech Learner

1,227
6
24
59

Passing C# DateTime to SQL Server stored procedure as DateTime parameter

1 Answers1