3 ms·
Make sure you're using signed integers larger than 32 bits if you ever need dates before ~1970 or after ~2030.
by hueving 9y ago
Make sure you're using signed integers larger than 32 bits if you ever need dates before ~1970 or after ~2030.
- duskwuff 9y agoSQLite's INTEGER type is 64 bits, and its REAL type is double-precision (64-bit) floating point. Either type is quite sufficient for representing a time. :)