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
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
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
3 matches
Mail list logo