how to insert date in MySQL

Question

i am developing window application using visual studio and c# i want to insert date in Mysql database table which having datatype date

using datetimepicker control of visual studio

i wrote an insert query like this (insert into table name values('"+ datetimepicker.value + "')

it give me following error

ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.47-community]Incorrect datetime value: '01-06-2010 00:00:00' for column 'Date' at row 1

can any one resolve this problem

You need to use an ISO 8601 formatted date (YYYY-MM-DD HH:MM:SS), eg: "2010-06-02 12:34:56". I'm not supplying this as an answer because I don't know how to reformat the date in c# — nickf
– nickf, Commented Jun 1, 2010 at 16:09

D'Arcy Rittich · Accepted Answer · 2010-06-01 16:07:16Z

2

Use parameterized queries instead. Your code is subject to SQL injection attacks.

answered Jun 1, 2010 at 16:07

D'Arcy Rittich

172k41 gold badges297 silver badges287 bronze badges

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

Comments

vaitrafra · Accepted Answer · 2010-06-01 16:14:01Z

0

the Mysql DATE() datatype have the Format: YYYY-MM-DD.

you must trim out the time part of the .NET date type OR you can use the Mysql DateTime DataType.

answered Jun 1, 2010 at 16:14

vaitrafra

6624 silver badges15 bronze badges