I have issue with converting
datetime
date
input string was not in correct format.
insert into TasksCopy (Start_Date)
values (CONVERT(date, '10/01/2017'));
insert into TasksCopy (Time)
values (CONVERT(time, '17:00:00'));
datetime
datetime
insert into TasksCopy (Start_Date)
values (CONVERT(date, datetime.date.ToString("mm/dd/yyyy")));
string query = $"insert into TasksCopy (Start_Date) values (CONVERT(date, @date));";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@date", dateTime.Date);
date
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")));