Re: [sqlite] strftime("%Y", "-1234-01-01") returns -123

2019-07-17 Thread Tanaka Akira
2019-07-16 21:26 Richard Hipp : > Perhaps you overlooked the following paragraph from the documentation: > > "These functions only work for dates between -01-01 00:00:00 and > -12-31 23:59:59 (julian day numbers 1721059.5 through 5373484.5). > For dates outside that range, the results of

Re: [sqlite] strftime("%Y", "-1234-01-01") returns -123

2019-07-16 Thread Richard Hipp
On 7/16/19, Tanaka Akira 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 -01-01 00:00:00 and -12-31 23:59:59

[sqlite] strftime("%Y", "-1234-01-01") returns -123

2019-07-16 Thread Tanaka Akira
Hi. I found a doubtful behavior of strftime("%Y"). strftime("%Y", "-1234-01-01") returns -123 but I feel it should be -1234. (But it can be error because the manual describes "%Y year: -".) % ./sqlite3 SQLite version 3.29.0 2019-07-10 17:32:03 Enter ".help" for usage hints. Connected to