ormlite read Date as 'yyyy-MM-dd'

Question

I need to read a sqlite databse given to me, so I cannot change the Date format (yyyy-MM-dd) in the tables. When I try to use ormlite to generate object for me, using the following annotation:

@DatabaseField(columnName = "REVISION_DATE", dataType = DataType.DATE_STRING)
public Date revisionDate;

it gives me the following error:

java.sql.SQLException: Problems with column 3 parsing date-string '2012-05-01'
      using 'yyyy-MM-dd HH:mm:ss.SSSSSS'

is there any place I can tell ormlite I want to use "yyyy-MM-dd" as the date string?

Answer 1

If you take a look at the ORMLite documentation about date formats you will see that it mentions the @DatabaseField.format field. Here are the javadocs for format. This allows you to set the Date format.

The following should work:

@DatabaseField(columnName = "REVISION_DATE", dataType = DataType.DATE_STRING,
      format = "yyyy-MM-dd")
public Date revisionDate;