Android Question sorting dates in sqlite

[Cenny]

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]

Hi,

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

 

[Erel]

Parse the dates in your B4A code and store the ticks values.

 

[Cenny]

Hi,

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

Thanks for the help.

Cenny

 

[Cenny]

Parse the dates in your B4A code and store the ticks values.

Thanks for the help.

Cenny