Using DateTime Cloumn in [Table Row to Variable Loop]

Hi ,

I have used following procedures :

Table Creator ----> Table Row To Variable Start --> Database Reader

the source table has the column which is supposed to be datetime,

everything seems OK , but when the value of that Column(Datetime) passed to

Database Reader to use in my SQL Scripts , it is considered as Integer.

for example 2015/01/01 is passes as 2013 .

what should I do to solve this issue?

 

thanks a lot

We are already discussing this in a separate thread:

https://www.knime.com/forum/knime-general/problem-when-deal-with-table-row-to-variable-loop