On 14 Jan 2015 at 23:13, Simon Slavin <slav...@bigfraud.org> wrote: > 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.
I would have thought that storing them as integers and then presenting them in a user-selected format is much more user-friendly. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users