On Thu, Apr 21, 2016 at 4:12 PM, jrhgame <jrhgame at 163.com> wrote:
> SELECT julianday('2016-04-15 12:10:10') ==>2457494.00706
> SELECT datetime(2457494.00706) ==>2016-04-15 12:10:09
>
fwiw, i've done lots and lots of testing with round-trip conversions
between those two formats, and it cannot be done 100% reliably (at least on
consumer-grade hardware). There is always a minority percentage of cases
which round/truncate one second here or there. It's particularly ugly when
it happens on a day boundary. You may see that the percentage of
occurrences is higher on ARM platforms, compared to i64.
--
----- 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
