> 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?
SQLite doesn't have datetime type and thus doesn't have any datetime format to use in the import. Your datetime is imported as simple string, whatever format it has. But if you've got nulls in all rows then you have some other problem. Pavel On Wed, Jun 9, 2010 at 4:34 AM, twoblink <alb...@achtung.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
