Dr Fragen in the operating room

SQLite Doesn't Do Dates


Apparently SQLite doesn’t have *very* good date handling.
It seems that there are no functions that will extract parts of a standard date format. What I mean is that there is no ability to extract `YYYY` from `MM-DD-YYYY`. That bites.
It means Matt’s going to have to *de-normalize* the dates used in [Squib][1]. My understanding is that he’ll have to add an extra table with just the year of whatever.