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

Mike Jonson

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

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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() +"')'";
Mike Jonson15y ago
Thanks, guys)))
Vulpes15y ago
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() +"')";
Mike Jonson15y ago
now show: Unclosed quotation mark after the character string ''.
Mike Jonson15y ago
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 Jonson15y ago
dt.ToUniversalTime().ToString(CultureInfo.CurrentCulture) too show error Conversion failed when converting date and/or time from character string
Dorababu Meka15y ago
Hi can you try this replace your dt with

dt.ToUniversalTime().ToString(CultureInfo.CurrentCulture)
Vulpes15y ago
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 Jonson15y ago
and how better without string.format?
Mike Jonson15y ago
dt have type datetime
Dorababu Meka15y ago
Why you are using string.format try with out using string.Format and what the variable type for 'dt'