The right timeformat was sqlite> SELECT STRFTIME('%Y', '2023-01-01');
sqlite> SELECT STRFTIME('%Y', '
2023-01-01
');
Which return a correct 2023
2023