CREATE TABLE TEST1 (STR1 TEXT,STR2 TEXT);
INSERT INTO TEST1 (STR1,STR2) VALUES ("20130112075501","20120112075501");
 
SELECT 
 
 
(
 
julianday(
substr(STR1,1,4) || "-" || substr(STR1,5,2) || "-" ||  substr(STR1,7,2) || "T" ||substr(STR1,9,2) || ":" || substr(STR1,11,2) || ":" || substr(STR1,13,2)
)
 -
julianday(
substr(STR2,1,4) || "-" || substr(STR2,5,2) || "-" ||  substr(STR2,7,2) || "T" ||substr(STR2,9,2) || ":" || substr(STR2,11,2) || ":" || substr(STR2,13,2)
)
 
)
 
 FROM TEST1;

Q1JFQVRFIFRBQkxFIFRFU1QxIChTVFIxIFRFWFQsU1RSMiBURVhUKTsKSU5TRVJUIElOVE8gVEVTVDEgKFNUUjEsU1RSMikgVkFMVUVTICgiMjAxMzAxMTIwNzU1MDEiLCIyMDEyMDExMjA3NTUwMSIpOwoKU0VMRUNUIAoKCigKCmp1bGlhbmRheSgKc3Vic3RyKFNUUjEsMSw0KSB8fCAiLSIgfHwgc3Vic3RyKFNUUjEsNSwyKSB8fCAiLSIgfHwgIHN1YnN0cihTVFIxLDcsMikgfHwgIlQiIHx8c3Vic3RyKFNUUjEsOSwyKSB8fCAiOiIgfHwgc3Vic3RyKFNUUjEsMTEsMikgfHwgIjoiIHx8IHN1YnN0cihTVFIxLDEzLDIpCikKIC0KanVsaWFuZGF5KApzdWJzdHIoU1RSMiwxLDQpIHx8ICItIiB8fCBzdWJzdHIoU1RSMiw1LDIpIHx8ICItIiB8fCAgc3Vic3RyKFNUUjIsNywyKSB8fCAiVCIgfHxzdWJzdHIoU1RSMiw5LDIpIHx8ICI6IiB8fCBzdWJzdHIoU1RSMiwxMSwyKSB8fCAiOiIgfHwgc3Vic3RyKFNUUjIsMTMsMikKKQoKKQoKIEZST00gVEVTVDE7