Enrico Thierbach <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
