Hello, SOS I want cr?ate base and I want create table on sqlite3 ans script python . Why import the phyton command in squilte? My name table si BASE SIREN.db 144 colunn text real entier numeric, .. I want D?clare type and style .. Leng ... HELP
Envoy? depuis mon mobile -------- Message original -------- Objet : [sqlite] Epoch time with timestamp in ms De : Marco Bambini ? : General Discussion of SQLite Database Cc : Hello I tried to convert an epoch time with a timestamp in milliseconds like 1393732179010 to a correct date but it seems like that the function: SELECT datetime(1393732179010, 'unixepoch', 'localtime'); is not able to detect ms resolution and incorrectly reports a negative date. How can I tell sqlite to interpret timestamp in ms? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
