I have this table:
CREATE TABLE IF NOT EXISTS "smstable" (
"_id" INTEGER,
"thread_id" INTEGER,
"address" TEXT,
"person" LONG,
"date" LONG,
"protocol" INTEGER,
"read" INTEGER,
"status" INTEGER,
"type" INTEGER,
"reply_path_present" INTEGER,
"subject" TEXT,
"body" TEXT,
"service_center" TEXT,
"locked" INTEGER,
"error_code" INTEGER,
"seen" INTEGER,
PRIMARY KEY("_id")
);
INSERT INTO "smstable" VALUES (1,3,'+4222062716',0,1539260029211,0,1,-1,1,0,NULL,'10','+4222001018',0,NULL,NULL);
Now I want to query the table and convert the field "date" into a readable format.
I tried:
SELECT _id, thread_id, address, person, datetime(date, 'unixepoch') FROM smstable
but datetime returns blank.