On 2/18/16, Eric Rubin-Smith <eas.bts at gmail.com> wrote:
>>
>>
>> select 2, 28 + (CAST(strftime("%j", c.year||"-12-31") AS INTEGER) %
>> 365)
>>
>
> Here you assume that all years have either 365 or 366 days. Would that it
> were so!
>
> Look at the year 1752 -- you may notice something odd happened that
> September. :-)
>
Only in Great Britain and her colonies. The transition from the
Julian calendar to the Gregorian calendar happened at different times
in different countries over a span of nearly four centuries.
SQLite only understand Gregorian calendar dates. If you ask for a
date prior to 1752 (or 1582) then SQLite gives you the "proleptic
Gregorian calendar" date.
--
D. Richard Hipp
drh at sqlite.org
