On 12/7/2012 11:35 AM, Simon Slavin wrote:
most of my systems store dates as strings in this format "YYYYMMDD".
Better still (IMHO), integers in the format YYYYMMDD (e.g. 20121207). Integers are stored a bit more compactly by SQLite, and are compared slightly faster. And you can still eyeball them for debugging purposes.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users