Android Question sorting dates in sqlite

Cenny

Active Member
Licensed User
Longtime User
Hi,

I have an Access database file where date data is saved in the format 'dd-mm-yyyy'.
How can I import these dates in sqlite so that they can be correctly sorted?

Thanks for your help
Cenny
 

Ohanian

Active Member
Licensed User
Longtime User
Hi,

Convert date field into Unix time format (long) and store them.
 
Upvote 0
Top