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

[Richard Hipp]

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