OpenCSV wrong date format

Question

I am using CsvToBean class of the openCSV. The bean has the date feild.

@CsvDate(value = "yyyy-MM-dd")
@CsvBindByPosition(position = 8)
private Date startDate;

I am doing the negative testing by passing the value "2018-25-02" but it is getting converted to Thu Jan 02 00:00:00 GMT 2020 without throwing any issue.

Answer 1

You could create your own custom converter for java 8 LocalDate, e.g.

public class LocalDateConverter extends AbstractBeanField {
    @Override
    protected Object convert(String s) throws CsvDataTypeMismatchException, CsvConstraintViolationException {
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        LocalDate parse = LocalDate.parse(s, formatter);
        return parse;
    }
}

Then you can just annotate your class like:

@CsvCustomBindByPosition(position = 8, converter = LocalDateConverter.class)
private LocalDate startDate;

Answer 2

OpenCSV 5

OpenCSV 5.x onwards supports Java 8 java.time APIs natively.

To quote the documentation:

Full support for the Java 8 Time API is included. Conversion to and from all JDK-types that implement TemporalAccessor is included.

The following should therefore suffice:

@CsvDate(value = "yyyy-MM-dd")
@CsvBindByPosition(position = 8)
private LocalDate startDate;