Working with timestamps and timezones is almost always a hassle. Moreover, SQLite doesn’t have a dedicated type to store such values. However, there are some built-in functions to simplify such tasks. In this post you’ll find a good example of using them in a real production app.
P.S. Here you’ll find a funny video about general problems with dates, time and timezones.
#sqlite #db #date
P.S. Here you’ll find a funny video about general problems with dates, time and timezones.
#sqlite #db #date
Handling Dates & Times in SQLite
Handling Dates & Times in SQLite :: Ryan Harter
SQLite may not have dedicated datetime data types, but that doesn't mean we have to restort to queries filled with meaningless numbers and post-processing datasets in application code. Here we'll take a look at a real world use case for SQLite's [datetime…