On 9 Jun 2010, at 9:34am, twoblink wrote: > in the csv; the field is defined like: > > 2010.03.31 16:01:24.284 For a datetime field.
SQLite does not have any such field type. > 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? You can't. Import it just as it is into a TEXT field. Then write some code to convert it into whatever date/time format you actually want (the format you want to store it as will depend on what you want to use it for). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
