[Squirrel-sql-users] Import File Plugin with Timestamp field

[tells1977 <ct...@gm...>]

I am attempting to import a CSV file into a database that has a TIMESTAMP
column.  

Create table DB2.TEST_Table (
	FIELD1		CHAR(18),
	FIELD2		CHAR(2),
	FIELD3		CHAR(5),
	FIELD4		CHAR(2),
	FIELD5		CHAR(1),
	FIELD6		CHAR(1),
	LD_TS          TIMESTAMP           NOT NULL    )

My input file would contain FIELDS1 - FIELDS6.  LD_TS is the load timestamp. 
I tried using fix format in the import function but I am unable to find a
value that will work correctly.  Is there any way to use the import function
and also populate the timestamp field?
-- 
View this message in context: http://old.nabble.com/Import-File-Plugin-with-Timestamp-field-tp33447560p33447560.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.