On 14 Jan 2015, at 10:40pm, Baruch Burstein <bmburst...@gmail.com> wrote:
> Of course, this is just at the theoretical level. As yo said, your app > probably wouldn't need to worry about this. I think a previous poster had it right. If you need to do lots of maths with the timestamps store unix epochs as INTEGERs (or Julian dates if you care only about date and not time). If, on the other hand, your database is read directly by a human a lot, store the dates as ISO format in TEXT. None of these formats have any problem-dates coming up, so we don't expect a y2k panic for any of them. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users