The easy way use dates in Android SQLite - Code Blow

Usually (just like I actually do in mysql/postgres) I stores dates in int(mysql/publish) or text(sqlite) to keep them within the timestamp format. I Quickly will convert them into Date objects and perform actions according to user TimeZone

codeblow.com