On Thu, May 5, 2016 at 10:08 AM, R Smith <rsmith at rsweb.co.za> wrote:
> seconds. Leap years themselves also have problems - the easiest check is
> to see if the year is divisible by 4 and then allow a 29th on Feb, but of
> course for the year 1900 this would have been wrong, but for 2000 this is
> right again, etc
i think this is easier: check if the year as 365 or 366 days:
sqlite> select strftime('%j', '2016-12-31');
366
sqlite> select strftime('%j', '2015-12-31');
365
with the usual caveats for dates in the far past.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
