To Unix Timestamp

Description

This operation converts a date and time into a Unix timestamp. A Unix timestamp is the number of seconds (or milliseconds) that have elapsed since January 1, 1970, 00:00:00 UTC (commonly referred to as the "Epoch").

---

Data types

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

Input data

- Strings representing the dates you want to transform.

Output data

- Integers representing the resulting Unix timestamps.

---

Parameters

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

Unit*

Specify the unit of time of the output timestamp. Choose one of the following:

• Seconds

• Milliseconds

• Microseconds

• Nanoseconds

---

Example

Suppose you want to convert a series of dates into Unix timestamps:

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

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

3. Set Time Unit to Seconds.

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

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

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.