Changing Date Format in Talend Studio 8

[VCimino1683560087]

Hi,

we are currently running a job with Talend Studio 8 where some Oracle queries are executed and the data exported to csv files.

We are not using neither tMap nor declaring schemas, we are dinamically managing the list of queries with a Loop, so we don't have control over the columns format retrieved from Oracle.

We would like to export oracle date in epoch time format.

Is there a way to change the date format in Talend without declaring schemas ?

I hope i was clear

[Anonymous]

Hi

I'm assuming you are using Dynamic schema, you need to access the schema's properties, change the data type and convert the date to epoch time format at run time. Pleaser refer to this KB article.

Regards

Shong

[VCimino1683560087]

Thanks for your reply @Shicong Hong​ .

We have a dynamic schema but we read data from a tDBInput component, not a tFileInputDelimited. We write the output in a csv file. See attached.

As i can see, i cannot connect a tDBInput with a tJavaRow component.

Maybe the solution is using tFileInputDelimited and tJavaRow staring from the csv output file ?

[Anonymous]

It's able to connect a tDBInput to a tJavaRow, I don't understand why you can't do it.

...tDBInput--main-->tJavaRow--main--tFileOutputDelimited

[VCimino1683560087]

Hi @Shicong Hong​ , yes i can do it. I was doing something wrong.

We are using tJavaFlex instead of tJavaRow because it seems more flexible.

Thank for the support.