On 8/16/16, Aaron Paul <[email protected]> wrote: > Greetings, > > I’m importing a csv file into a newly created table with .import. One of > the columns contain a numerical tag which sometimes resembles a date > (example 08-17). > > These are not dates, but the .import is converting 08-17 into 17-Aug
No it's not. The sqlite3.exe command-line shell does not know how to do such things, nor does the SQLite core. This undesired conversion must be happening somewhere else in your tool chain. Double-check your CSV file. Are you *sure* that Excel is not doing the conversion of 08-17 to 17-Aug before generating the CSV? How are you viewing the resulting database file? Are you using sqlite3.exe? Or are you using a third-party tool that might be doing this undesired conversion upon display? > > The odd thing is it is doing this even when the date doesn’t make sense, > like 35-September. > > Any thoughts on how to avoid this? There are about 1500 rows in this table > and I’d rather import them correctly than try some scheme to clean it up, > but thoughts on that would be appreciated if nothing else. > > Thanks! > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
