topic Changing Date Format in Talend Studio 8 in Talend Studio

Changing Date Format in Talend Studio 8

VCimino1683560087 — Fri, 15 Nov 2024 21:46:19 GMT

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

Re: Changing Date Format in Talend Studio 8

Anonymous — Wed, 24 May 2023 11:24:58 GMT

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

Re: Changing Date Format in Talend Studio 8

VCimino1683560087 — Wed, 24 May 2023 13:20:29 GMT

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 ?

Re: Changing Date Format in Talend Studio 8

Anonymous — Wed, 24 May 2023 14:32:38 GMT

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

Re: Changing Date Format in Talend Studio 8

VCimino1683560087 — Thu, 25 May 2023 08:16:07 GMT

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.