home ~ projects ~ socials

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.

-- end of line --

References