SQLite Forum

strange strftime returns at julian day zero
Login
The beginning of the Julian day epoch is 4714 BC (Nov 24, noon Greenwich, Gregorian Proleptic calendar.)

From the datetime documentation, the "%Y" conversion is not defined for BCE years.

https://www.sqlite.org/lang_datefunc.html

%Y		year: 0000-9999