John wrote: > On 5/10/2014 19:59, Clemens Ladisch wrote: >> 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. > > All equivalent functions should return consistent results.
Why do you assume that "undefined" should imply consistency? datetime() could return "Cthulhu fhtagn" at the Ides of any month in such a year, and there would be nothing wrong with it. Undefined allows _anything_. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users