On 7/16/19, Tanaka Akira <a...@fsij.org> wrote: > Hi. > I found a doubtful behavior of strftime("%Y"). > > strftime("%Y", "-1234-01-01") returns -123
Perhaps you overlooked the following paragraph from the documentation: "These functions only work for dates between 0000-01-01 00:00:00 and 9999-12-31 23:59:59 (julian day numbers 1721059.5 through 5373484.5). For dates outside that range, the results of these functions are undefined." -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users