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. Permitted date formats are the ones allowed by the Go time package. Check this article to see all the valid formats.

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:

2006-01-02 15:04:05 -> 1136214245

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.

Last updated

Was this helpful?