News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by coleifer on Monday February 12, 2018 @10:52AM (#16359402)
The lack of a datetime data-type hasn't been a problem in my experience. I have, at different times, stored the timestamp as an integer representing number of microseconds since the epoch, or stored in YYYY-mm-dd HH:MM:SS (which sorts lexicographically so comparisons come out right). SQLite has some built-in facilities for working with datetimes as well, along the lines of strftime, etc.

H2, being java, is in a whole different universe from SQLite...not a valid comparison in my view.

Re:Appropriate Uses for SQLite by mulmen on Monday February 12, 2018 @02:47PM (#16361426)
...in UTC. Right? RIGHT?!
Re:Appropriate Uses for SQLite by HumanDrivenDev on Monday February 12, 2018 @04:10PM (#16362189)
Not going to lie, after reading that I quickly went to check that "Date.now()" in javascript returned UTC.