I am trying to import data
from another tracking system. Unfortunately my data is (now) in an Excel file
which I have exported as CSV and am reformattings as INSERT statements to use
with sqlite3.
All seems fine, except for
dates and timestamps. My "closed" date for example is in a date string like
"2006-08-11 18:06:47". I cannot figure out how to import it into
sqlite3.
The statement below does
not work:
INSERT INTO "ticket"
VALUES(1, 'defect', '2006-08-11 18:00:00', '2006-08-11 18:06:00', 'component1',
NULL, 'major', 'somebody', 'rnmixon', '', '4.0.11', '', 'closed', 'fixed',
'Ticket Summary (example)', 'Ticket Description (example)',
'');
I have read the sqlite doc,
and tried the datetime functions - but they all seem intent on taking a
date that is already in integer format and displaying it.
Also, I'm not really
Python-literate (yet) - so that may be part of what I am
missing.
Any suggestions are
appreciated. I did search the list archives but did not find what I was looking
for
_______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
