Saturday, 7 September 2013

c# - Replacing dates in a large file with a format usable by MySql for BulkLoad

c# - Replacing dates in a large file with a format usable by MySql for
BulkLoad

I am using MYSqlBulkLoader to load a text file into a mysql db table.
However, the date format in the file is mm/dd/yyyy and MySql expects the
date in yyyy-mm-dd format. What is the best and the fastest way to replace
all the dates in the text file with a proper format ? Also, Is there a way
to make MySql accept the date format mm/dd/yyyy ?

No comments:

Post a Comment