This article explains how to convert a Unix timestamp to a readable date in a Talend Job.
This procedure was written with:
Talend verified this procedure to be compatible with:
A Unix timestamp is a series of numbers such as 13959.583,1330578363. As you can see, it is quite unreadable. This procedure explains how to convert it to a readable date or map it to the target system format.
Assume we have the following Unix timestamp in a file:
13959.583 1356854 1330578363
Create a demo Job called ConvertUnixTime. The detailed Job settings can be seen below:
Execute the Job. The following results are output to the console:
Starting job ConvertUnixTime at 14:47 01/03/2012. [statistics] connecting to socket on port 3659 [statistics] connected 01-01-1970 11:52:39 17-01-1970 00:54:14 01-03-2012 13:06:03 [statistics] disconnected Job ConvertUnixTime ended at 14:47 01/03/2012. [exit code=0]