Re: [sqlite] a bug, date() cannot handle dates in range -1000-0000 (1000BC-0BC)

2019-08-25 Thread Keith Medcalf
On Saturday, 24 August, 2019 11:12, Petr Slansky wrote: >past, I tried to find some old dates and I found a bug in date() >function for date in range -1000- (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

Re: [sqlite] a bug, date() cannot handle dates in range -1000-0000 (1000BC-0BC)

2019-08-25 Thread J. King
On August 24, 2019 1:12:21 p.m. EDT, Petr Slansky wrote: >I discovered julianday() function and because it is linked to the >distant >past, I tried to find some old dates and I found a bug in date() >function for >date in range -1000- (1000BC-0BC): > >sqlite> select date('-1000-01-01'); -- OK

[sqlite] a bug, date() cannot handle dates in range -1000-0000 (1000BC-0BC)

2019-08-25 Thread Petr Slansky
I discovered julianday() function and because it is linked to the distant past, I tried to find some old dates and I found a bug in date() function for date in range -1000- (1000BC-0BC): sqlite> select date('-1000-01-01'); -- OK -1000-01-01 sqlite> select date('-0999-01-01'); -- BUG, should