To_char and TO_Date functions in Talend????????

[ankit7359]

Hi,

I was going through the Talend Date functions and i came across parseDate and formatDate functions/routines....

But can we use to_char or to_date functions in Talend and if yes how can we use them....????

Pls help.

Thanks in advance

[Anonymous · Accepted solution]

Hi,

     to_char and to_date functions are used to convert the data types when you are running queries from Oracle database to fetch the data. But these functions cannot be used within the tmap or or other similat Talend components.

     If you are comfortable processing data using above functions, my recommendation will be to convert the data when you are fetching them using tOracleInput component. But if you have to do data conversion within Talend, you will have to use Talend/java data conversion functions.

    If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi