How to convert .net DateTime to SQL Server DateTime2

Question

I want to insert DateTime variable into database table column of DateTime2 type (from .net program) (im using sqlServer 2008, .net 4.0, c#)

now I have

     string insertCommand = @"INSERT INTO X VALUES (time.ToString());

Problem is in time string format. SQL Server does not work with output from ToString() function. I also tried .ToLongDate short date etc.. How to create proper sql command and how to format dateTime string to make this work?

deostroll · Accepted Answer · 2011-05-31 05:56:02Z

2

Try this:

string sql = "insert into x values (@dt)";
SqlCommand cmd = cxn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@dt", time);
cmd.CommandText = sql;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();

edited May 31, 2011 at 5:56

answered May 30, 2011 at 12:43

deostroll

12k22 gold badges94 silver badges168 bronze badges

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

1 Comment

Pradip Over a year ago

Considering time as datetime of C#, when I do the same, only the date is stored in the database and not the timestamp. Why is that ?

SLaks · Accepted Answer · 2011-05-30 12:40:42Z

1

You need to add a parameter with your DateTime value.

answered May 30, 2011 at 12:40

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Comments

Deepesh · Accepted Answer · 2011-05-30 12:38:57Z

0

not confirm but you can use use format times.tostring("dd/MMM/yyyy") like http://msdn.microsoft.com/en-us/library/az4se3k1.aspx

answered May 30, 2011 at 12:38

Deepesh

5,6346 gold badges32 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to convert .net DateTime to SQL Server DateTime2

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