in windows service storing datetime in MYSQL database exception

i will be tested the application as windows application then it will be stored the datetime in MySQL data base.when i will be start this application using windows service it will be thrown this exception.

error [HY000][MySQL][ODBC 3.51 Driver] [MySqlid -6.0.11-alpha-community]incorrect datetime value '5/6/2011 9:00:00 AM' for column column-name at row1"

windows application take the system format & my system format is yyyy-MM-dd hh:mm:ss in windows service which format is used.

 string dt1 = Convert.ToString(DateTime.FromFileTime(e.sts[counter].TimeS开发者_运维问答tamp));
Datetime dt2 = DateTime.ParseExact(dt1,"MM-dd-yyyy hh:mm:ss", CultureInfo.InvariantCulture);

i will be checked the date format of the MYSQL write this code but it will be display the unrecognized string format

If you are recording the time of the windows service event as it happens then I would use the MySQL NOW() function in your query.