Note: This site is currently "Under construction". I'm migrating to a new version of my site building software. Lots of things are in a state of disrepair as a result (for example, footnote links aren't working). It's all part of the process of building in public. Most things should still be readable though.

SQLite Dates

These notes are from 2015. I need to look back at the date time functionality to see what thing look like now (or if it Iwas soing it a weird way.

There might have been back then and I was just doing it this way regardless.

I need to look into that and update this page

The approach I'm using for SQLite dates is to simply store them as INTs in the format:

YYYYMMDD

It doesn't look like you can use the built in date/time function with that, but it's easier to search for dates before and after that way which is more important.

References