Re: [sqlite] trouble with sqlite .import

2016-08-17 Thread Aaron Paul
Hi Richard, Thanks for your answer. I had been looking at the csv exported data in Excel and it looked right. I opened the csv file in a plain text editor and it was as you said, the data was already in date format. Formatting the Column and re-exporting the csv file corrected my issue. M

Re: [sqlite] trouble with sqlite .import

2016-08-17 Thread R Smith
On 2016/08/17 4:54 AM, Aaron Paul 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 The odd t

Re: [sqlite] trouble with sqlite .import

2016-08-17 Thread Richard Hipp
On 8/16/16, Aaron Paul 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.

[sqlite] trouble with sqlite .import

2016-08-17 Thread Aaron Paul
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 The odd thing is it is doing this even when the date