John wrote: > -4713-11-25 12:00:00 <-- 4 digit year > -471-11-25 12:00:00 <-- 3 digit year > -001-12-31 <-- 3 digit year > -001-12-31 <-- 3 digit year > -1975-10-21 <-- 4 digit year > -197-10-21 <-- 3 digit year
The documentation <http://www.sqlite.org/lang_datefunc.html> says: | These functions only work for dates between 0000-01-01 00:00:00 and | 9999-12-31 23:59:59. For dates outside that range, the results of | these functions are undefined. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users