topic Re: Convert timestamps with java in Talend Studio

Convert timestamps with java

DrGenious — Mon, 27 Jan 2020 09:26:35 GMT

Hi,

I have a column with many timestamps and I want to convert them from string to date but with java , not with tmap.

Thanks you.

Re: Convert timestamps with java

Anonymous — Mon, 27 Jan 2020 13:30:00 GMT

Use timestamp functions in tjavaRow.

Re: Convert timestamps with java

DrGenious — Mon, 27 Jan 2020 13:52:20 GMT

@ravinderk This is very generic. I asked for some help.
Thanks god , I figure it out somehow

In tjavarow

//input the column with the date-string

String sDate1=input_row.newColumn2;

//parse with the format that our string has ! If We want other format we can change it in "edit schema".
Date date1=new SimpleDateFormat("dd-MM-yy HH:mm").parse(sDate1);

If someone has a different and better solution please post it.