add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1(acctinfo TEXT)

INSERT INTO table1(acctinfo) VALUES
('{"AcctCreateTime": 1518112456, "LastLoginTime": 1601055231, "LastModified": 1518112456}')

SELECT datetime(json_extract(acctinfo, '$.LastLoginTime'), 'unixepoch', 'localtime')
FROM table1;
{
  "code": "SQLITE_ERROR"
}