Error Conversion failed when converting date and/or time from character string

Question

Every time this error problem with dt.

strSql = string.Format("Insert InTo MoneyEntries (Amount, EntryDate, Description, IDCategory)" +
"Values ('{0}', '{1}', '{2}', '{3}')", am, dt, desc, int.Parse(rdr[0].ToString()));

In my table Entrydate have type easy date. Please help

Vulpes · Answer

If it's the same problem as the other thread (Sql Server), where the day and month needed to be reversed, I'd try: strSql = "Insert InTo MoneyEntries (Amount, EntryDate, Description, IDCategory) Values ('" + am.ToString() + "','" + dt.ToString("MM/dd/yyyy") + "','" + desc.ToString() + "','" + rdr[0].ToString() +"')'";

Vulpes · Answer

There looks to be a superflous single quote after the final closing bracket, which needs removing: strSql = "Insert InTo MoneyEntries (Amount, EntryDate, Description, IDCategory) Values ('" + am.ToString() + "','" + dt.ToString("MM/dd/yyyy") + "','" + desc.ToString() + "','" + rdr[0].ToString() + "')" ;

Vulpes · Answer

It may be that the DateTime you're passing (on which, by default, the ToString() method is being called) is not in the correct format for whatever database you're using. We had another thread on this problem recently ( http://www.c-sharpcorner.com/Forums/Thread/131973/inserting-date-value.aspx ). Also I'm surprised it works at all without a space before 'Values'. I'd also remove the single quotes for the int value.

Mike Jonson · Answer

Thanks, guys)))

Mike Jonson · Answer

now show: Unclosed quotation mark after the character string ''.

Mike Jonson · Answer

strSql = "Insert InTo MoneyEntries (Amount, EntryDate, Description, IDCategory) Values ('" + am.ToString() + "','" + "{d'" + dt.ToString() + "'}'" + "','" + desc.ToString() + "','" + rdr[0].ToString() +"')'"; Show error Incorrect syntax near '18.07'.. Cant undestand why?

Mike Jonson · Answer

dt.ToUniversalTime().ToString(CultureInfo.CurrentCulture) too show error Conversion failed when converting date and/or time from character string

Dorababu Meka · Answer

Hi can you try this replace your dt with dt . ToUniversalTime (). ToString ( CultureInfo . CurrentCulture )

Mike Jonson · Answer

and how better without string.format?

Mike Jonson · Answer

dt have type datetime

Dorababu Meka · Answer

Why you are using string.format try with out using string.Format and what the variable type for 'dt'

Error Conversion failed when converting date and/or time from character string

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (11)