topic UNIX EPOCH to date in Talend Studio

UNIX EPOCH to date

DrGenious — Mon, 03 Feb 2020 14:10:01 GMT

Hey,

I have a date "1569387782831" it is unix epoch and I want to convert it to human readable date with tjavarow. Can someone help please?

Thanks.

Re: UNIX EPOCH to date

TRF — Mon, 03 Feb 2020 14:21:07 GMT

This may help https://community.talend.com/t5/Design-and-Development/How-to-convert-of-epoch-time-to-human-readable-format/td-p/21634

Re: UNIX EPOCH to date

DrGenious — Mon, 03 Feb 2020 14:34:03 GMT

@TRF Thanks a lot for the quick response it was very helpful but I have one more question. Instead of printing it with system.out how can I parse it into a row? For example output_row.created_time . I asked it because it shows me an error cant convert from string to date, but I changed in my schema the type from string to date with pattern.

Re: UNIX EPOCH to date

TRF — Mon, 03 Feb 2020 15:19:50 GMT

This should work:
output_row.created_time = sdf.format(new Date(utime)));