Hallo list, how would you tackle this problem?
I have to add a number of times into the database. They come from "real live" sources, that, for example, say: "Sunday, March 13th, 2pm", or "Sunday, April 3rd, 2pm". Here in Central Europe we switch to DST on the last weekend of March, therefore the first time is "2011-03-13 14:00 UTC+1" (or "2011-03-13 14:00 CET"), while the latter is "2011-04-03 14:00 UTC+2" (or "2011-04-03 14:00 CEST"). Now sqlite already knows about DST. Does anyone see a way to use that already? I would hate to reinvent the wheel and to code this myself :) Thank you, /eno _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users