You should be using single quotes for string delimiters. Additionally, you are
seeing right handed truncation of a 5 character string in a 4 character field
asql> select strftime('%Y','-0123-04-05');
strftime('%Y','-0123-04-05')
----------------------------
-123
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Tanaka Akira
Sent: Dienstag, 16. Juli 2019 14:08
To: sqlite-users@mailinglists.sqlite.org
Subject: [EXTERNAL] [sqlite] strftime("%Y", "-1234-01-01") returns -123
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
___________________________________________
Gunter Hick | Software Engineer | Scientific Games International GmbH |
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43
1 80100 - 0
May be privileged. May be confidential. Please delete if not the addressee.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
