Hi Fabian, It happens even if i change the table declartion so that column A is timestamp. Fabian Groffen wrote:
On 30-12-2008 01:50:32 -0800, Alfred Nordman wrote:
Hi Fabian,
The error i get is: !SQLException:sql:value '?»¿1997-01-01 00:00:00' while parsing '?»¿1997-01-01 00:00:00|City Mall|1110|6165|33|8122' from line 0 field 0 not inserted, expecting type date !SQLException:importTable:failed to import table
It seems like some chars (?»¿) are added to the first row inserted to the table. The chars do not appear in the csv file (attached).
Yeah, looks like garbage in the rendering. But I think the most important part is "expecting type date". You specified a datetime. If you want to really have date (1997-01-01) you need to change your CSV (remove the 00:00:00), or do the modification in the database after loading your dataset with a datetime instead of a date for column "A".
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21215907.html Sent from the monetdb-users mailing list archive at Nabble.com.