convertunix

Introduction

Use the convertunix instruction to convert a UNIX timestamp into an easy-to-read datetime format.

Creating a custom script transformation using the convertunix instruction

To create and configure a custom script using the convertunix instruction, follow these steps:

1. Create a custom script transformation.

2. In the Instruction step, select the convertunix instruction.

3. To configure the custom script instruction, fill in the following fields. Required fields are marked with an asterisk (*).

Fields

Enter the name of the column containing the UNIX values to convert.

As Date

Select this option to return the UNIX time as a date value only. Leave unselected to return the UNIX time as date and time.

Fail on Error

Select this field to stop the transformation instruction if an error occurs.

Errorvalue

Enter the value with which to populate the field if an error occurs.

Example