db2 date format without HHmmss

KNIME Analytics Platform
1

Hi,

I need to insert some rows in db2 with a lot of date format column.

At the start my columns are in string format:  2014-02-04

I can use the StringToDate node to convert these string and it works (04feb2015) but i need an amount of node equal to the number of date format column.

Can i do this job with a Java Snippet?

TimeZone.setDefault(TimeZone.getTimeZone("GMT"));
DateFormat f = new SimpleDateFormat("yyyy-MM-dd");
try{
out_DT_INS =  f.parse(c_DT_INS);
}catch(Exception e){}

If i convert the string with the SimpleDateFormat the output value is like 04feb2015 00:00:00 and the database writer goes in error.

The database writer works fine only if i use the MaskDateTime node to mask the 00:00:00...but i need an amount of node equal to the number of date format column :(

How can i crop this part into the java snippet?

Thanks

2

Doesn't exists a way to crop the time inside the java snippet?