How to inser DateTime into the MySql Database

[santosh95808]

Hi friends,

I am finding some difficulties in the inserting date time into the database.

I am not able to convert the datetime into the mysql's Date Time format i.e.
'yyyy/mm/dd hh:mm:ss'

pls anybody can help me

[Plater]

DateTime is not kept as a string, that's just how it is shown to you.
You should be able to use a Paramater and set the type to DateTime, then add the datetime object to it.

Example:

DateTime EDate = DateTime.Now;
com.Parameters.Add("@EndDate", SqlDbType.DateTime);
com.Parameters["@EndDate"].Value = EDate;
 

[santosh95808]

DateTime is not kept as a string, that's just how it is shown to you.
You should be able to use a Paramater and set the type to DateTime, then add the datetime object to it.

Example:

DateTime EDate = DateTime.Now;
com.Parameters.Add("@EndDate", SqlDbType.DateTime);
com.Parameters["@EndDate"].Value = EDate;
 

But i want to know how to write a command like insert because i am inserting so many things into the table and among those DateTime is one feild....

[Plater]

So write your command using the parameter?

http://bytes.com/forum/thread635615.html

http://bytes.com/forum/thread817960.html