>This is why ISO8601 format was invented and why it should be used. >The "instant time offset" from UT1 (which is not the timezone) should >only ever be excluded if the datetime expressed is already in UT1.
The caveat here of course being that UT1 times with offsets (stored as ISO8601 strings) (unless all the offsets are the same) cannot be sorted without converting them first to have the same UT1 offset, or to another format that is a numeric offset from the same base epoch. Storing the data as pure UT1 (and excluding the offset entirely) solves this issue efficiently because then the string data inherently sorts into the correct order and the localization can then be re-applied afterwards for display to the user (resulting in correct ordering for daylight time shifts, political shennanigans, and the like). --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
