Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • UNIX Timestamp to Date&Time
NodeNode / Manipulator

UNIX Timestamp to Date&Time

Other Data Types Time Series Transform Streamable
Drag & drop
Like
Copy short link

Parses the integer or long values in the selected columns and converts them into Date&Time cells. The inputs should be unix timestamps either in seconds, milli-, micro- or nanoseconds since the epoch (1.1.1970).
For the output you may choose between local and zoned date and time formats and if necessary add the timezone.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing the parsed columns.

Extension

The UNIX Timestamp to Date&Time node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Z_018_timestamp
    tommy > Public > Z_018_timestamp
    tommy
  2. Go to item
    Z_018_timestamp
    mauricio1201 > Public > Z_018_timestamp
    mauricio1201
  3. Go to item
    Convert to OHLC
    elsamuel > Public > TotalDataLoss > Convert to OHLC
    elsamuel
  4. Go to item
    Tickdata in OHLC kompri
    totaldataloss > Public > Tickdata in OHLC kompri
    totaldataloss
  5. Go to item
    Multiply1000
    totaldataloss > Public > Multiply1000 > Multiply1000
    totaldataloss
  6. Go to item
    Tickdata to OHLC_V2
    totaldataloss > Public > Tickdata to OHLC_V2 > Tickdata to OHLC_V2
    totaldataloss
  7. Go to item
    various date and time formats including R
    demonstrate how to switch between various date formats in old and new KNIME date format, …
    mlauber71 > Public > kn_example_r_date_formats_extended
    mlauber71
  8. Go to item
    R to zip and unzip data
    using different R packages and KNIME to zip and unzip files
    mlauber71 > Public > kn_example_r_zip_archiv > m_005_zip_with_r
    mlauber71
  9. Go to item
    YahooFinanceGetQuotes
    lsambruna > Public > YahooFinanceGetQuotes
    lsambruna
  10. Go to item
    Dataanalysprojekt
    anton312 > Public > Dataanalysprojekt
    anton312
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits