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: 0000-9999".)
% ./sqlite3
SQLite version 3.29.0 2019-07-10 17:32:03
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT strftime("%Y", "-1234-05-06");
-123
sqlite>
% ./sqlite3 -version
3.29.0 2019-07-10 17:32:03
fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
I built sqlite3 from sqlite-autoconf-3290000.tar.gz downloaded today.
% ls ..
sqlite-autoconf-3290000 sqlite-autoconf-3290000.tar.gz
--
Tanaka Akira
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
