SQLite Forum

Inconsistency in BETWEEN Query
Login
> I can't use "int" because of the length of the numbers. If I cast the query as "long", can you guarantee that all query ranges will run without errors?

sqlite does not distinguish between "long" and "int". See:

<https://www.sqlite.org/datatype3.html>