C# DateTime changing to another format

Question

Sir/Madam,

I am going to perform Oracle bulk insert but invalid bind parameter Papameters : System.dateTime warns here.

The field of Created Date is timestamp(0) which 22-MAR-13 08.13.27.000000000 PM is only accpeted format.

but when I trying to convert from string to DateTime as follows:

3/22/2013 8:00:00PM

using the following method:

 item.CreatedDate = Convert.ToDateTime("19-MAR-13 08.13.27 PM");

// BELOW IS ORACLE BULK INSERT

        using (OracleConnection myConnection = new OracleConnection(myConnectionString))
        {
            myConnection.Open();
            using (var copy = new OracleBulkCopy(myConnection))
            {
                copy.DestinationTableName = "T_BQ";
                copy.BulkCopyTimeout = 10;
                copy.BatchSize = 1000;
                var query = from item in list select item;
                var dt = new System.Data.DataTable();
                dt = ConvertToDataTable(query);
                copy.WriteToServer(dt);
                copy.Dispose();
                copy.Close();
            }
            myConnection.Dispose();
            myConnection.Close();
        }

have you checked my answer ?

Mohammad Arshad Alam
– Mohammad Arshad Alam

2013-03-25 07:14:11 +00:00
Commented Mar 25, 2013 at 7:14 — Mohammad Arshad Alam
– Mohammad Arshad Alam, Commented Mar 25, 2013 at 7:14

Mohammad Arshad Alam · Accepted Answer · 2013-03-25 07:11:52Z

3

You can use DateTime.TryParseExact for custom datetime format as:

 string strDateStarted = "19-MAR-13 08.13.27 AM";
 DateTime datDateStarted;
 DateTime.TryParseExact(strDateStarted, new string[] { "dd-MMM-yy hh.mm.ss tt" }, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out datDateStarted);
 Console.WriteLine(datDateStarted);

answered Mar 25, 2013 at 7:11

Mohammad Arshad Alam

9,8626 gold badges41 silver badges63 bronze badges

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

Comments

Iswanto San · Accepted Answer · 2013-03-25 03:06:03Z

3

You should using : for time separator instead .

Try this:

item.CreatedDate = Convert.ToDateTime("19-MAR-13 08:13:27 PM");

answered Mar 25, 2013 at 3:06

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

2 Comments

Jeff Bootsholz Over a year ago

Invalid parameter binding Parameter name: System.DateTime happens

Iswanto San Over a year ago

@RajuGujarati: post more code in your question especially the code that caused the error.

Yuliam Chandra · Accepted Answer · 2013-03-25 03:19:14Z

2

try this,

dateVariable.ToString("MM/dd/yyyy hh:mm:sstt");

answered Mar 25, 2013 at 3:19

Yuliam Chandra

14.7k12 gold badges56 silver badges70 bronze badges

Collectives™ on Stack Overflow

C# DateTime changing to another format

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related