On 12 May 2016, at 3:55pm, Jonathan Moules <jonathan-lists at lightpear.com> wrote:
> I know that the "DATE" type isn't actually a type in SQLite and that there > are no date-specific constraints, but I find it a convenient indicator (to me > and potentially anyone else who's going to see the code) as to the type of > data that is to be held in that column. I figured that's why those "type" > synonyms exist (I use DATETIME as well!) What you don't mention there is that defining that column as DATE is what's causing the weird-looking results you asked about. Simon.
