On 12 Jun 2009, at 4:08pm, Allen Fowler wrote: > If you have any suggestions for how start planning for multiple TZ > and UTC / DST support, I would be very interested to hear.
All date data should be stored as UTC. It is extremely difficult to get this right later if you don't start off doing it correctly. Take a look at 'localtime' and 'utc' on <http://www.sqlite.org/lang_datefunc.html> > Also, do you have any thoughts on how to query the event table for > each user's "shortest event"? You could be storing event duration, not stop time. Or perhaps store both. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users