On Tue, Apr 17, 2012 at 11:18 AM, Mark Jones <m...@jonesgroup.co.uk> wrote: > I think I'll spend the time going back and storing the dates as integer > time (since the epoch) as Nico suggested and just use strftime to convert > them as and when required.
Note that you'll lose any fractional second information when you do this. On the other hand, fractional second information does not sort properly when compared as text, so if you need sub-second resolution you need to work a little harder. (Huh, that is strange. Is there a canonical way to compare timestamps with fractional seconds in SQLite3?) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
