Syntax Error Converting DateTime From Character String

Question

I am trying to insert a row in ms-sql table using the following code

SqlCMDText = "INSERT INTO attendance(date, time_in, time_out, time_total, status,";
SqlCMDText += "  is_late_in, is_half_day, is_early_out, user_id, remarks)";
SqlCMDText += " VALUES('@yestarday_date', 'NA', 'NA', 'NA', 'ABSENT', 'NA', 'NA', 'NA', 52, 'DONE BY PORTAL')";
SqlCMD = new SqlCommand(SqlCMDText, SqlCON);
SqlCMD.Parameters.AddWithValue("@yestarday_date", Yestarday);
SqlCMD.ExecuteNonQuery();

Where Yestarday is a string variable containing short date format like "04/04/2011". I also tried passing datetime variable itself but it does not work, I get same error as below.

"Syntax Error Converting DateTime From Character String"

What format should I use to make it work?

Thanks.

your column is a datetime? so adding a parameter as a datetime should work — lnu
– lnu, Commented Apr 29, 2011 at 7:39

Jude Cooray · Accepted Answer · 2011-04-29 07:41:16Z

1

Use DateTime.Parse(Yestarday)

SqlCMD.Parameters.AddWithValue("@yestarday_date", DateTime.Parse(Yestarday));

answered Apr 29, 2011 at 7:41

Jude Cooray

19.9k21 gold badges85 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ahmed Over a year ago

Thanks a lot Ranhiru this worked. DateTime.Parse(Yestarday). But I still don't understand why direct DateTime object is not working it should work I think.

jgauffin · Accepted Answer · 2011-04-29 07:39:55Z

1

You should use the DateTime object directly. If you get another error, post that one.

answered Apr 29, 2011 at 7:39

jgauffin

101k45 gold badges245 silver badges378 bronze badges

Comments

Patrick D'Souza · Accepted Answer · 2013-04-27 18:55:31Z

0

Try the following code.

CurDate = DateTime.ParseExact(@Yestarday, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture, System.Globalization.DateTimeStyles.None)

edited Apr 27, 2013 at 18:55

Patrick D'Souza

3,5592 gold badges25 silver badges40 bronze badges

answered Apr 29, 2011 at 7:42

Sai Kalyan Kumar Akshinthala

11.9k8 gold badges45 silver badges68 bronze badges

Collectives™ on Stack Overflow

Syntax Error Converting DateTime From Character String

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related