Skip to main content Skip to complementary content

Converting a UNIX timestamp to a readable date

Procedure

  1. Create a .txt file example of a unix timestamp with the following data:
    13959.583
    1356854
    1330578363
  2. Create a Job named ConvertUnixTime, composed of a tFileInputdelimited, a tMap and a tLogRow component linked by two main rows:
  3. Double-click tFileInputdelimited to open its Component view and fill the File name/Stream field with path of the .txt file you created for example, "D:/file/in.txt".
  4. Click the ellipsis button (...) to edit the schema of the component and add a new column named unixDate.
    Information noteNote: The data entered can be read with double, float or long type.
  5. Double-click tMap to configure it, drag and drop the unixDate column of the input table to the output table.
  6. Enter new java.util.Date((long)(row1.unixDate*1000)) into the expression box of the output table column.
  7. Change the Type of the data to Date in the Schema editor and enter the following Date pattern: "dd-MM-yyyy HH:mm:ss".Your should have the following schema:
  8. Execute the Job. The following results are output to the console:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!