Ormlite read Date as 'yyyy-MM-dd'

Question

I need to read the sqlite database provided to me, so I cannot change the date format (yyyy-MM-dd) in the tables. When I try to use ormlite to create an object for me using the following annotation:

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

it raises 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 a place where I can specify ormlite I want to use "yyyy-MM-dd" as a date string?

Answer 1

If you look at the ORMLite documentation on date formats , you will see that it refers to 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;