I'm trying to parse a csv entry "2021-05-09T12:23:55+0100" as an OffsetDateTime using openCsv as follows:
@CsvDate(value = "yyyy-MM-dd'T'HH:mm:ssZ")
override var orderTimeStamp: OffsetDateTime? = null
Based on various suggestions from other posts, I've tried out the following formats:
- "yyyy-MM-dd'T'HH:mm:ssZ"
- "yyyy-MM-dd'T'HH:mm:ss'Z'"
- "yyyy-MM-dd'T'HH:mm:ss+ZZZZ"
- "yyyy-MM-dd'T'HH:mm:ss'+'Z"
- "yyyy-MM-dd'T'HH:mm:ssX"
- etc...
Each time, I get the same error:
com.opencsv.exceptions.CsvDataTypeMismatchException: Conversion of 2021-05-09T12:23:55+0100 to java.time.OffsetDateTime failed.
Does anyone know which specific format would correctly parse this? Thanks!