batch fail to write - database writing into postgresql - due to date data type

KNIME Analytics Platform
#1

While writing data into postgresql i put batch size 1000
when i give varchar to date then i can successfull dump data at destination

but when give date and time as data type to date coloumn at that time i cant dump data…
whole batch is fail to dump data…

1001 row fail
2001 row fail
like that

can someone help me in that-- as of now i am push as varchar
but my team not able to fetch data properly

#2

Hi there!

Not sure I understand correctly. You get error when writing Date&Time column type from KNIME to Date column type in PostgreSQL or? And when writing String column from KNIME to Date column in PostgreSQL you don’t get error or? What is the exact error you get?

Br,
Ivan

#3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.