Import CSV to Database not able to insert data for date field

Hello bhragavip,

I am not sure what your error, will need to make a dive into the plugin components to tell you more information about this.

As an alternative option I think you can consider (something like ETL/ELT style) .
1) Loading the data first to a table(staging/temporary table) strings will make your life easie, (same plugin)
2) Transform it to the type you want. ( maybe in a procedure)
3) Load the data to your desired table. ( maybe the same procedure)

Jose

Hi I can try this way but the data is huge which I am loading from CSV to data base , so it leads to performance issue.

Hi I can try this way but the data is huge which I am loading from CSV to data base , so it leads to performance issue.

Sorry I haven't replied earlier,

The databases normally perform really good when processing information. The other day I was thinking that maybe you can transform the information with a trigger while inserting it In case you don't want to load information and then executing a store procedure.

If i had to implement this I would pick the option to first bulk the information to a table and then run a stored Procedure, because this is little more flexible and maybe you will be able to debug easier or add extra processing in case is needed.

BTW I am curious, how huge is huge?

Jose

Hi , thanks for info. The data will be 35000 records with 5 columns .
My issue resolved like if I format the CSV file column with date and with following format 'yyyy-MM-dd HH:MM:SS '
Where I understood from a Oracle db guy that in Oracle date means date and time , and dateTime means date and time with timestamp. So with this plugin if we send the data as date and time , then it's working fine.