What: The handleTimestamp used a hard-coded simpledateformat as "SimpleDateFormat("dd-MMM-yyyy HH:mm:ss"); ", When using the CSVWriter.writeAll(), it doesn't provide an argument to define the dateformat. when dumping a database to CSV file, it converts the datetime column from "2011-7-28 11:11:11" to "2011-七月-28 11:11:11"(I'm using CN locale), this will cause bugs when importing this generated CSV to sqlserver because it only accepts strings like "2011-7-28 11:11:11" and convert it into datetime.
The error is as followings:
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting datetime from character string.
Suggestion for fix: Maybe we can let the user pass the format they want as an argument? I believe hard code this kind of format is not the best solution.
First time using sourceforge:)
Log in to post a comment.