Using a SQLite date/time field with Flutter and Dart
As a brief note, at the time of this writing, SQLite doesn’t have date/time (datetime) fields, so when you want to use a datetime field with Flutter and Dart, you have to do something else.
Solution: My choice was to store my date/time data as a SQLite INTEGER
field. I did this so I can query and sort that field easily myself. The benefit of storing a datetime field as a TEXT
field is that you can read it easier, but I think an INTEGER
field is a little easier to work with, though YMMV.