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. My understanding is that he’ll have to add an extra table with just the year of whatever.
Related posts:
- SQLite and Squib Thanks to Matt, and my persistence, Squib now works and...
- Archives done right Hooray for #256. Matt’s got Squib doing archives a better...
- SQLite and Rails I’ve tried, in my extreme inexperience, to run Squib with...
Related posts brought to you by Yet Another Related Posts Plugin.