Send date from C# to SQL Server

Question

I have issue with converting

datetime

in C# to

date

in SQL Server.

I constantly get this error message:

input string was not in correct format.

I tried this query

insert into TasksCopy (Start_Date) 

values (CONVERT(date, '10/01/2017'));

It worked in SQL Server Management Studio, but didn't work using C# program in Visual Studio.

However the query below worked in both Visual Studio and Management Studio:

insert into TasksCopy (Time) 

values (CONVERT(time, '17:00:00'));

I tried this way using my C# app to send

datetime

variable called

datetime

:

insert into TasksCopy (Start_Date) 

values (CONVERT(date, datetime.date.ToString("mm/dd/yyyy")));

however that still did not work.

The code below did not work either:

string query = $"insert into TasksCopy (Start_Date) values (CONVERT(date, @date));";



SqlCommand command = new SqlCommand(query, connection);

command.Parameters.AddWithValue("@date", dateTime.Date);

That also did not work.

What is the correct way to send data to SQL Server as

date

data type?

Thanks in advance

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

date managing is always a pain no matter what language, but somehting that seems to always work in SQL engines is to send the date string as

yyyy-mm-dd

So you can try something like this:

insert into TasksCopy (Start_Date) values (CONVERT(date, datetime.date.ToString("yyyy-mm-dd")));

Send date from C# to SQL Server

Sign up