On Mon, Oct 22, 2012 at 11:38 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Oct 2012, at 3:42am, John Gabriele <jmg3...@gmail.com> wrote: > >> Which column affinity is most customary to use for storing "YYYY-MM-DD >> HH:MM:SS" datetime values? > > Text. They are just text. As you've figured out, SQLite has no datetime > datatype. > ...
Thanks, Richard, Igor, and Simon! Very clear now. Much appreciated. :) (Incidentally, I'm also grateful for the examples in the docs at http://www.sqlite.org/lang_datefunc.html . They make a nice addition, IMO, to the prose and the diagrams in the documentation. And it's also handy that I can copy/paste them right into my `sqlite>` prompt to try them out.) ---John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
