Bug #5906: CSV converter option fails in case of :date_time

• Status: Rejected
• Assignee: JEG2 (James Gray)
• Target version: -
• ruby -v: ruby 1.9.3p0 (2011-10-30 revision 33570) [i686-linux]

[steenslag (siep korteling)]

The built-in converters of CSV with the name :date_time does not convert dates, nor does the :any converter

[naruse (Yui NARUSE)]

• Category set to lib
• Status changed from Open to Assigned
• Assignee set to JEG2 (James Gray)

[zzak (zzak _)]

• 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.

[JEG2 (James Gray)]

• 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.