Hi, I have a few gigs of csv information I need to import; using SqliteMaestro works but imports about 1000 rows / sec and I have a few hundred million rows, so that's not a real solution.
I did the .mode csv, .import from the sqlite3 program, and everything imported fine except the datetime field. It came up null. in the csv; the field is defined like: 2010.03.31 16:01:24.284 For a datetime field. I would like to tell sqlite that this is in YYYY.mm.dd hh:mm:ss.sss How can I define this in sqlite's program so it imports the datetime correctly? Thanks. Albert -- View this message in context: http://old.nabble.com/Date-format-definition-on-bulk-csv-insert-tp28827421p28827421.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
