News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by module0000 on Monday February 12, 2018 @01:15PM (#16360574)
This may not be helpful to you, but I've always used the epoch time stored in sqlite. It's blazing fast, indexes well(integers !), and is 100% convertible to any format you might need to represent.
Re:Appropriate Uses for SQLite by hueving on Monday February 12, 2018 @01:40PM (#16360802)
Make sure you're using signed integers larger than 32 bits if you ever need dates before ~1970 or after ~2030.
Re:Appropriate Uses for SQLite by duskwuff on Monday February 12, 2018 @02:46PM (#16361418)
SQLite'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. :)