How to pass the output of one oracle sql to other oracle sql in talend

[Anonymous]

I am trying to create the 2 sqls. In first sql my output will be the last runtime of the Table and in another sql I want to feed this output as input for 2nd sql. I am trying to pass the variable through Tflow to iterate component. But here it is taking the default date (Java.util.date) as the input to my second sql and getting the error as invalid relation operator.
I need to pass the date format as "dd-MMM-YY hh:mm:ss:ssz" in the second sql but whereas from the tflow to iterate component giving the dateformat as "Mon Apr 08 22:00:06 IST 2019". 

Please suggest how to fix this in flowto iterate component and provide the suggestion on if any other component is there to iterate the values ?

[Anonymous]

@NewUser395 

I could see that you have created one more post for the same query. 

https://community.talend.com/t5/Design-and-Development/How-to-pass-the-output-of-one-oracle-sql-to-o...

Please create only one post for one query as it will save the time and effort of other Talend community members in between  their busy schedules.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi,
Due to network issue it got created twice. Tried to delete the same but
couldn't able to find the option