datetime format mismatch in schema .ini

See more:

C#3.5

hi all,

i have a text file which is (|) delimited and it has nearly 1.5 lakh rows.

i need to import this text file to mysql using c#. the date time format is in the file
02/10/2014 16:24:47.
how i will get the date time format in mysql type like yyyy-MM-dd HH:mm:ss?. i tried with
datetimeformat=yyyy-mm-dd in the schema file but it's not working..

i created schema file

[file_name.txt]
colNameHeader=True
Format=Delimited(|)
MaxScanRows=0
col1= FName Text
col2=Op_Time DateTime
col3=LName Text
col4=TimeSpent Double
col5=Status Text
col6=Group Text
col7=R_Time DateTime
col8=Type Text