On 14 Jan 2015, at 5:53pm, Nigel Verity <nigelver...@hotmail.com> wrote:
> I generally just use a fixed-length 14-character string to store the date and > time in YYYYMMDDHHMMSS format. It accommodates any time stamp across a 10,000 > year timespan and also supports simple date/time comparisons and sorting. There is no problem with using that format. However I would advise you to make a note in your documentation, and/or to add comments to your code, saying what TimeZone these stamps are in. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users