From Unix Timestamp

Description

This operation converts Unix timestamps into human-readable date and time formats. Unix timestamps represent the number of seconds (or milliseconds) that have elapsed since the Unix epoch, which began at 00:00:00 UTC on January 1, 1970.

---

Data types

These are the input/output expected data types for this operation:

Input data

- Integer values representing the Unix timestamps to be converted.

Output data

- A string representing the formatted time.

---

Parameters

These are the parameters you need to configure to use this operation (mandatory parameters are marked with a *):

Time Unit*

Specify the unit of time represented by the input timestamp. Choose one of the following:

• Seconds

• Milliseconds

• Microseconds

• Nanoseconds

Timezone Output

Specify the timezone of the input date strings. Enter one of the following:

• UTC

• GMT

• PST

• PDT

• CET

• CEST

• Any IANA time zone

If not provided, the default value is UTC.

Format Output*

Specify the desired format of your output date strings.

Note that the reference date that you must use for both the Input Format and Output Format parameters is the following:

• Date - January 02, 2006

• Time - 15:04:05

Following the example in the Input Format parameter, imagine you have this input date 2024-10-24T14:11:13Z and set the Input Timezone to UTC+1.

If you enter the following in the Output Format parameter:

• 02/01/2006 15:04:05

and set Output Timezone to UTC+8, you will get this as your output date:

• 24/10/2024 21:11:13

The following formats are supported for both the Input Format and Output Format parameters:

• RFC3339 (for example 2006-01-02T15:04:05Z)

• ANSIC (for example Mon Jan 2 15:04:05 2006)

• UnixDate (for example Mon Jan 2 15:04:05 PST 2006)

• Custom format (for example 02-01-2006 15:04:05)

---

Example

Suppose you want to convert a series of timestamps into human-readable date strings:

1. In your Pipeline, open the required Action configuration and select the input Field.

2. In the Operation field, choose From Unix Timestamp.

3. Set Time Unit to Seconds.

4. Set Timezone Output to UTC.

5. Set Format Output to Mon 2 January 2006 15:04:05 UTC

6. Give your Output field a name and click Save. The values in your input field will be transformed. For example:

978346800 -> Mon 1 January 2001 11:00:00 UTC

You can try out operations with specific values using the Input field above the operation. You can enter the value in the example above and check the result in the Output field.