Home
Head's Up: I'm in the middle of upgrading my site. Most things are in place, but there are something missing and/or broken including image alt text. Please bear with me while I'm getting things fixed.

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.

Footnotes And References