SQLite does not recognize "Z" as the zero offset time zone specifier. "Z" (for 'Zulu time', an alternative name for UTC) is part of the ISO 8601 standard for date and time representations. See http://en.wikipedia.org/wiki/ISO_8601 for details.
In this regard, SQLite does not currently follow the standard and rejects the following valid ISO 8601 dates as NULL: select datetime ('1981-04-06T14:45:15Z'); select datetime ('14:45:15Z'); As far as I can tell, "Z" support only requires a very minor change in date.c, parseTimezone() to recognize the if the "Z" character is present. No further timezone modification is necessray. A test case scenario would be datetest 5.8 {datetime('1994-04-16 14:00:00Z')} {1994-04-16 14:00:00} # According to Wikipedia, timezone should directly follow time. # SQLite, however, allows whitespace inbetween. # Question: Does this conform to ISO 8601? datetest 5.9 {datetime('1994-04-16 14:00:00 Z')} {1994-04-16 14:00:00} # Whitespace after Z. datetest 5.10 {datetime('1994-04-16 14:00:00Z ')} {1994-04-16 14:00:00} # Whitespace before and after Z. datetest 5.11 {datetime('1994-04-16 14:00:00 Z ')} {1994-04-16 14:00:00} If "Z" timezone support was implemented, I would volunteer to update the date time function documentation in the SQLite Wiki. Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users