SQLite Forum

sqlite3 rounding off the values of timestamp causing issues
Login
The problem is you are storing REAL values in a TEXT column. 

asql> create table tvr (t text, r real);
asql> insert into tvr values (1536738388.3623876328,1536738388.3623876328);
asql> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE tvr (t text, r real);
INSERT INTO "tvr" VALUES('1536738388.36239',1.53673838836238765715e+09);
COMMIT;