DateTime formatting in .Net for MySQL database

Question

How do I format the string result of DateTime.Now in C# for insertion into a MySQL database table column of type DATETIME?

I have tried the following without any success:

insert blah 
  (Id, Content, DateCreated) 
  select 123, 'Blah blah blah', 1/5/2010 9:04:58 PM

insert blah 
  (Id, Content, DateCreated) 
  select 123, 'Blah blah blah', '1/5/2010 9:04:58 PM'

Not sure about MySQL, for SQL Server I use "yyyy-MM-dd HH:mm:ss" — MikeW
– MikeW, Commented Jan 6, 2010 at 2:11

Thomas Levesque · Accepted Answer · 2010-01-06 02:14:51Z

5

Don't put literal dates in the query, use parameters instead. That way you don't have to worry about the format. It is also safer for strings entered by users, because it prevents SQL injections.

command.Text = "insert into myTable(myDate) values(?dateParam)";
command.Parameters.Add("?dateParam", theDate);

edited Jan 6, 2010 at 2:14

answered Jan 6, 2010 at 2:08

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

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

1 Comment

Joel Coehoorn Over a year ago

Always use parameters like this: for all your data types, not just date times.

Randolpho · Accepted Answer · 2010-01-06 02:11:44Z

1

Use a parameterized MySqlCommand rather than building your own query and pass a DateTime to as the parameter. No formatting necessary.

answered Jan 6, 2010 at 2:11

Randolpho

56.5k18 gold badges153 silver badges182 bronze badges

Collectives™ on Stack Overflow

DateTime formatting in .Net for MySQL database

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related