Hello,
When I don't use the parameter dateFormat, I get some strange results for columns that aren't in the default format yyyy-MM-dd.
I have this text-file:
id;ddmmyyyyFormat;mmddyyyyFormat;yyyymmddFormat
10;10-01-1900;01-10-1900;1900-01-10
And this url:
jdbc:csv:/.?delayedClose=0;_CSV_Separator=\\x3b;_CSV_Quoter=\";_CSV_Header=true
Both the second and third column are being returned as dates, although they don't fit the format.
But even worse, is that the value 10-01-1900 (Januray 10th) is wrongly translated. It is the Dutch (Italian) format dd-MM-yyyy, but the the result is Octobre 1st.
Kind regards,
Remco Schoen
|
|
If you set dateFormat=yyyy-MM-dd as connection property, the latest package won't think 10-01-1900 or 01-10-1900 as date any more. Without that connection property, it will think it's date format.
|
So, if I understand correctly, the parameter dateFormat controls two functions?
The first being if used, it checks if the string is in the right format and the second which format is specified.
I find that really confusing, because the driver will return false dates, if you forget the parameter.
According to your documentation (http://www.hxtt.com/text/installation.html#url) the default for this parameter is yyyy-MM-dd. I would expect that when the parameter isn't supplied, that this format is being used AND that the strings as well are checked if they are in this format.
|
>According to your documentation (http://www.hxtt.com/text/installation.html#url)
>the default for this parameter is yyyy-MM-dd. I would expect that when the
>parameter isn't supplied
The latest package will work like your suggestion.
|
|
Yup, this works now as expected. Thanks.
|
Main
webmaster@hxtt.com