CSV converter option fails in case of :date_time
The built-in converters of CSV with the name :date_time does not convert dates, nor does the :any converter
Updated by zzak (Zachary Scott) over 7 years ago
- File 0001-test-csv-test_data_converters.rb-test_builtin_date_time_converter_with_stamp.patch 0001-test-csv-test_data_converters.rb-test_builtin_date_time_converter_with_stamp.patch added
I've added a failing test to confirm this.
Updated by JEG2 (James Gray) almost 7 years ago
- Status changed from Assigned to Rejected
- % Done changed from 0 to 100
The converters do work, just not on the date format you gave them.
Your format is ambiguous. Should we treat it as month-day-year as it would be in the U.S. or day-month-year as it would be in the U.K.? Because we can't know, we don't support that format by default. The year-month-day format is supported, plus month name, day year. These are chosen because they are unambiguous.
If you need to support a different format, just add your own converter. You will know how your dates look, so it's easy for you to parse it correctly.
I hope that makes sense.