UNIX Timestamp to Date&Time

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.

Options

Column Selection

Column Selector

Only the included columns will be parsed.

Replace/Append Selection

Append selected columns

The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.

Replace selected columns

The selected columns will be replaced by the converted columns.

Input Format

Input unit

The unit of the input unix timestamp. May be either milli-, micro- or nanoseconds.

Output Format

New type

The type of the new data cells can be selected.

Timzone

A timezone with an optional offset, e.g. 'UTC', 'GMT+2' or 'CET-1'. Is only used if 'Zoned Date&Time' is selected as the New Type.

Views

This node has no views

Workflows

• 78996 - Heat Map based on Geo Data Lat and LongKNIME Hub
• ADS-B_2KNIME Forum
• all-data-loadedKNIME Hub
• conversion-from-unix-timestamp-to-date-21737NodePit Space
• Convert Excel DatesKNIME Forum
• Convert milli seconds to timeKNIME Forum
• Convert to OHLCKNIME Hub
• Convert to OHLC_v2KNIME Hub
• DashboardKNIME Hub
• DataanalysprojektKNIME Hub
• Dataanalysprojekt 2KNIME Hub
• Dataanalysprojekt 2 20210225KNIME Hub
• Dataanalysprojekt 2 20210225(2)KNIME Hub
• diavgeia_methods1KNIME Hub
• EarthquakeKNIME Hub
• Excel Date Serial to DateTimeKNIME Hub
• ExplorationKNIME Hub
• Export_to_DB_BrunoKNIME Forum
• Fix missing datesKNIME Forum
• Fix missing dates - with missing first and last dateKNIME Forum
• GPS Map TokyoKNIME Hub
• Gudadanal API CallsKNIME Hub
• kn_example_db_sqlite_window_rank_timestampKNIME Hub
• kn_example_hive_school_ofKNIME Hub
• kn_example_r_date_formats_extendedKNIME Hub
• m_005_zip_with_rKNIME Hub
• Main ProcessKNIME Hub
• Mongodb OID to timestamp conversionKNIME Forum
• Monitor User UsageKNIME Hub
• Multiply1000KNIME Hub
• NLSQL_Llama3.2(Ollama)KNIME Hub
• Ollama - Chat with LLama3KNIME Hub
• Proyecto boliviaKNIME Hub
• rk timeKNIME Forum
• Round up times to next quarter hourKNIME Forum
• SCB_Power_ProductionKNIME Hub
• SensorDashboardKNIME Hub
• snow_depthKNIME Hub
• Solution_Round_4_Team_AST (Public_Version)KNIME Hub
• SQLite - Long Integers and UNIX Timestamps - KNIME Forum (76744)KNIME Hub
• Tickdata in OHLC kompriKNIME Hub
• Tickdata to OHLC_V2KNIME Hub
• Tickdata to OHLC_V2_ipazinKNIME Forum
• TrainingDashboardKNIME Hub
• updating values in loopKNIME Forum
• updating values in loop 2KNIME Forum
• Weather DashboardKNIME Hub
• Yahoo Finance Stock price grabberKNIME Hub
• Z_018_timestampKNIME Hub
• Z_018_timestampKNIME Hub
• Погода APIKNIME Hub
• Погода APIKNIME Hub
• Погода APIKNIME Hub

Links

• Conversion from Unix timestamp to Dateby qqilihq on 2020-03-12

  forum.knime.com/p/84243
• CSV Data can not seperate between time stamp and valueby mlauber71 on 2019-01-10

  forum.knime.com/p/52612

Developers