LogoLogo
WebsiteBlogLogin
  • Onum Docs
  • Use Cases
  • Videos
  • Release Notes
  • Welcome
  • Getting Started
    • About Onum
    • Architecture
    • Deployment
    • Getting Started with Onum
    • Understanding The Essentials
      • Cards and Table Views
      • Data Types
      • Graph Calculations
      • The Time Range Selector
    • Key Terminology
  • THE WORKSPACE
    • Home
    • Listeners
      • Cloud Listeners
      • Listener Integrations
        • Amazon SQS
        • Amazon S3
        • Apache Kafka
        • Azure Event Hubs
        • Cisco NetFlow
        • Google Pub/Sub
        • HTTP
        • HTTP Pull
        • Microsoft 365
        • OpenTelemetry
        • Syslog
        • TCP
      • Labels
    • Pipelines
      • Building a Pipeline
        • AI Assistant
          • AI Pipeline Assistant
          • AI Action Assistant
      • Listeners
      • Actions
        • Advanced
          • Anonymizer
          • Bring Your Own Code
          • Field Generator
          • For Each
          • Google DLP
          • HTTP Request
          • Redis
        • Aggregation
          • Accumulator
          • Group By
        • AI
          • Amazon GenAI
          • BLIP-2
          • Cog
          • Google GenAI
          • Llama
          • Replicate
        • Detection
          • Sigma Rules
        • Enrichment
          • Lookup
        • Filtering
          • Conditional
          • Sampling
        • Formatting
          • Message Builder
        • Transformation
          • Field Transformation
            • Field Transformation Operations
              • Arithmetic / Logic
                • Divide Operation
                • Median
                • Multiply Operation
                • Subtract Operation
                • Sum Operation
              • Code tidy
                • JSON Minify
              • Control characters
                • Escape String
                • Unescape String
              • Conversion
                • Convert Area
                • Convert Data Units
                • Convert Distance
                • Convert Mass
                • Convert Speed
                • List to String
                • String to List
              • Data format
                • From Base
                • From Base64
                • From Hex
                • To Base
                • To Base64
                • To Hex
              • Date / Time
                • From Unix Timestamp
                • To Timestamp
                • To Unix Timestamp
                • Translate Datetime Format
              • Encoding / Decoding
                • From Binary
                • To Binary
                • To Decimal
              • Encryption / Encoding
                • JWT Decode
              • File system permissions
                • Parse Unix file permissions
              • Format conversion
                • CSV to JSON
                • JSON to CSV
              • Hashing
                • Keccak
                • MD2
                • MD4
                • MD5
                • SHA0
                • SHA1
                • SHA2
                • SHA3
                • Shake
                • SM3
              • Networking
                • Defang IP Address
                • Defang URL
                • Extract IP Address
                • Fang IP Address
                • Fang URLs
                • IP to Hexadecimal
                • Parse URI
                • URL Decode
                • URL Encode
              • Other
                • Parse Int
              • String
                • Length
              • Text sample adding
                • Pad Lines
              • Utils
                • Byte to Human Readable
                • Count Occurrences
                • CRC8 Checksum
                • CRC16 Checksum
                • CRC24 Checksum
                • CRC32 Checksum
                • Credit Card Obfuscator
                • Filter
                • Find and Replace
                • Regex
                • Remove Whitespace
                • Reverse String
                • Shuffle
                • Sort
                • Substring
                • Swap Case
                • To Lower Case
                • To Upper Case
          • Flat JSON
          • JSON Transformation
          • JSON Unroll
          • Math Expression
          • Parser
            • PCL (Parser Configuration Language)
        • Utils
          • Unique
      • Data sinks
      • Bulk Changes
      • Publishing & Versioning
      • Test your Pipeline
    • Data sinks
      • Data sink Integrations
        • Amazon S3
        • Amazon SQS
        • Azure Blob Storage
        • Azure Event Hubs
        • Devo
        • Google BigQuery
        • Google Cloud Storage
        • Google Pub/Sub
        • HTTP
        • Jira
        • Mail
        • Null
        • OpenTelemetry
        • PagerDuty
        • Pushover
        • Qradar
        • Relational Databases
        • ServiceNow
        • Slack
        • Splunk HEC
        • Syslog
        • TCP
        • Telegram
        • Twilio
    • Alerts
  • YOUR VAULT
    • Enrichment
    • Data History
    • Actions
  • ADMINISTRATION
    • Tenant Menu
    • Global Settings
      • Your Account
      • Organization Settings
        • Secrets Management
      • Tenant
        • Authentication
        • Users
        • Activity Log
  • MARKETPLACE
    • Onum Marketplace
      • Pulling Pipelines
        • Netskope Events Alert
        • OKTA System Log API
        • Sophos Connector SIEM
Powered by GitBook
On this page
  • Description
  • Data types
  • Input data
  • Output data
  • Parameters
  • Example

Was this helpful?

Export as PDF
  1. THE WORKSPACE
  2. Pipelines
  3. Actions
  4. Transformation
  5. Field Transformation
  6. Field Transformation Operations
  7. Date / Time

From Unix Timestamp

PreviousDate / TimeNextTo Timestamp

Last updated 2 months ago

Was this helpful?

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. If not provided, the default format is ddd d mmm yyyy hh:mm:ss timezone (for example, Mon 2 Jan 2006 15:04:05 MST)

Note that you must use the following date to represent your required output format:

  • Date - January 02, 2006

  • Time - 15:04:05

For example, imagine you have this input timestamp 978346800 and you want to get the corresponding date in this format: ddd dd mmm yyyy hh:mm:ss

You must enter the following in the Format Output parameter, considering the date above:

  • 02 January 2006 15:04:05

You will get this as your output date:

  • 12 January 1970 07:45:46

These are some of the supported formats:

  • 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)

Note that custom formats must have day, month, year, and time. For example, this format Mon Jan 2 15:04:05won't work, as it is missing the year.


Example

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

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

  2. Set Time Unit to Seconds.

  3. Set Timezone Output to UTC.

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

  5. 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.

You can use any date format supported by . For a complete list of supported formats, check .

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

Go
this article
Action