Hello, SQLite datetime function correctly parses timestring with timezone: sqlite> select datetime('2013-04-30T18:38:54Z'); 2013-04-30 18:38:54 sqlite> select datetime('2013-04-30T20:38:54+02:00'); 2013-04-30 18:38:54
But this is not documented: http://sqlite.org/lang_datefunc.html http://sqlite.org/datatype3.html#datetime May I suggest updating these pages accordingly. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users