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

Question

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

I am passing {4/1/2017 12:00:00 AM}

from my C # code to SQL Server as a parameter to a stored procedure. And in a stored procedure, I want to convert this to a format MMddyyyy

for processing data. I tried many suggestions from google but nothing works for me.

Throwing this error:

Converting varchar datatype to datetime datatype resulted in out of range value

+3

c # sql-server sql-server-2008-r2

Ask_SO Apr 28 17 at 7:42

source to share

1 answer

G01 · Answer 1 · 2017-04-28T07:45:24+0000

Try to convert the keyword in SQL, but you need to pass some parameter value (101,107) to convert.

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

More articles: