SQLite dates and Django

I was getting very confused with my django DB quite happily setting the date in SQLite, but displaying a ” when loading it back from SQLite.

The SQLite field was a DATETIME, and in Django a ‘DateField, which I would have thought should work.

Alas, no.

Apparently the SQLite field must be a varchar(20) (or similar) for a date w/o time.

Strange.

Leave a Reply