Dates and SQLite

[Ricky D]

When we use a date in B4A should the definition for dbutils be DB_INTEGER or DB_REAL ?

I don't know if DB_INTEGER will hold the long that a date is in B4A

regards, Ricky

 

[Erel]

It should be DB_INTEGER. DB_INTEGER can accurately represent "long" numbers (8 bytes).

 

[Ricky D]

:sign0060:

thanks again Erel.

 

[inakifeliu]

Thanks Erel, I had the same question.
:sign0098: