On Saturday, 24 August, 2019 11:12, Petr Slansky <slan...@usa.net> wrote:
>past, I tried to find some old dates and I found a bug in date() >function for date in range -1000-0000 (1000BC-0BC) There is no 0 BC. The day immediately before 0001-01-01 AD/CE was 0001-12-31 BC(E), and what you refer to as -1000 is really 1001 BC(E). The SQLite3 datetime functions operate in astronomical years and the behaviour with use of negative astronomical years is undefined. The input/output routines could be changed such that the sign indicated AD/BC but presently this is not the case. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
