Enrico Thierbach <e...@open-lab.org> wrote:
> 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 :) 

select datetime('2011-03-12 14:00', 'utc'), datetime('2011-03-13 14:00', 'utc');
2011-03-12 19:00:00 | 2011-03-13 18:00:00

That's for EST (New York time), which switches to DST on 3/13 at 2 am.
-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to