store Current Date & time in MySql Using ASP.net

Question

I want to store the current date & time which can be get by System.DateTime.Now in asp.net but while storing in Mysql it gives Error of Invalid Time.

Answer 1

What is the column type of your time column? I assume it's DateTime

You should not put the datetime in it through ASP.NET but directly in your query:

"INSERT INTO table (dateColumn, someVar) VALUES (NOW(), \"something\")"

Answer 2

why don't you use the MySQL now() function?

insert into mytable 
       ( id, MyDate  ) 
values ( 42, now()   )

If that is not possible, you will need to look into converting the client side date format into something the DB will understand.

Answer 3

MySql stores DateTimes in the format 'YYYY-MM-DD HH:MM:SS'

So you need to do

System.DateTime.Now.ToString("YYYY-mm-dd HH:MM:SS");