[sqlite] BUG?

[Richard Hipp]

On 4/21/16, jrhgame <jrhgame at 163.com> wrote:
> SELECT julianday('2016-04-15 12:10:10')  ==>2457494.00706

I get: 2457494.00706019

The extra digits at the end ...019 make the difference.

> SELECT datetime(2457494.00706)           ==>2016-04-15 12:10:09

SELECT datetime(2457494.00706019)  ==> 2016-04-15 12:10:10

-- 
D. Richard Hipp
drh at sqlite.org