HXTT Text(CSV)
Conversion of date in wrong format
Remco Schoen
2009-11-09 05:01:32.0
Hello,

If I have a date like '01-28-1900' and use the parameter dateFormat=MM-dd-yyyy, then the driver doesn't recognize it as a false date and returns the date '1902-04-01'. I would expect an exception, that it can not convert the string to a date.

With kind regards,

Remco Schoen
Re:Conversion of date in wrong format
HXTT Support
2009-11-10 05:25:29.0
Checked. The latest package added date verification, and will throw an exception like "Value 1902-04-01(row 2, column ddmmyyyyFormat) is not DATE type".
Re:Re:Conversion of date in wrong format
Remco Schoen
2009-11-11 06:43:06.0
I can confirm this works now like expected.

I had to rewrite a lot of tests, but that is a little price to pay for such a convenient functionality! Great job!


Google