topic Re: timestamp format in Talend Studio

timestamp format

Anonymous — Sat, 16 Nov 2024 07:53:56 GMT

Hello everyone,

I'm using talend open studio data integration and new to this tool.

I have a csv file that has timestamp column and i'm trying to convert this in the schema of the input delimted_file. and I get the below error.

Couldn't parse value for column 'Tx_Timestamp' in 'row1', value is '07-JUL-18 05.17.36.000 PM -05:00'. Details: java.lang.RuntimeException: Unparseable date: "07-JUL-18 05.17.36.000 PM -05:00"

I tried this various options like "dd-MMM-yy HH.ms.ss.SSS a Z" but nothing helped.

Please let me know.

Re: timestamp format

vboppudi — Wed, 25 Jul 2018 19:56:05 GMT

Are you looking for the following output?

Regards,

Re: timestamp format

Anonymous — Wed, 25 Jul 2018 20:51:24 GMT

Yes this is exactly the output I need . so I need to us this following below to convert it?

TalendDate.ParseDateinUTC ( )

and I won't be able to use this in the FileInput_Delimted . under edit schema? Correct?

I can use it in tmap in expression editor and use that as a separate column/variable?

Thanks!

Re: timestamp format

Anonymous — Thu, 26 Jul 2018 11:33:45 GMT

Hi bro!

When I have to convert a TimeStamp field to a DateTime field, I like to create a routine in Talend for these purpose, and I'm going to show you how with a simple example where I've got a .csv input with a TimeStamp in milliseconds connected to tMap and the tMap output to a .csv output where I'm going to have two fields, the old timestamp and his correspondent DateTime.

-> This is the .CSV file input

Now I'm going to show you the talend routine to convert timestamp in milliseconds to datetime ("dd:mm:YY HH.mm.ss.SSS")

In the next step, you only have to aplpy the created routine in the tMap output option, expression builder!

Now just Run the job and woalah! \(^.^)/

-> .CSV file output

Pls, give me some Kudos if my response help you

Thanks for your time and attention ❤️

Re: timestamp format

Anonymous — Fri, 17 Aug 2018 22:37:34 GMT

Hi,

I have a date format in the below form in the csv file. how can I convert this?

2015-01-01T05:00:00Z

or what is the expression used I can store in the proper format?

Please help

Re: timestamp format

vboppudi — Fri, 17 Aug 2018 22:48:54 GMT

Hi,

Please try below.

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'Z'","2015-01-01T05:00:00Z")

Regards,

Re: timestamp format

Anonymous — Fri, 17 Aug 2018 22:56:49 GMT

thanks for the quick one...