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
Replace/Append Selection
Input Format
Output Format
Popular Predecessors
- Math Formula4 %
- String to Number4 %
Excel Reader (XLS)3 %- String Manipulation3 %
- Column Filter2 %
- Concatenate2 %
- Category to Number2 %
- Table Manipulator1 %
- Double to Integer1 %
- Java Snippet (simple)1 %
- Date&Time Difference1 %
- Date&Time to String1 %
File Reader1 %Number To String1 %- Column Resorter1 %
- Constant Value Column1 %
- String to Date&Time1 %
- CSV Reader1 %
- String Replacer1 %
Excel Reader (XLS)1 %- Variable to Table Row1 %
Extract Date&Time Fields< 1 %- String to Date/Time (legacy)< 1 %
- Cell Splitter< 1 %
- Timer Info< 1 %
- DB Query Reader< 1 %
- Loop End< 1 %
- Joiner< 1 %
- Modify Time Zone< 1 %
Table Reader< 1 %- Table Creator< 1 %
Row Splitter (deprecated)< 1 %- Table Transposer< 1 %
- Ungroup< 1 %
Parquet Reader< 1 %- Unpivot< 1 %
- Date&Time Part Extractor< 1 %
Concatenate (Optional in)< 1 %- GroupBy< 1 %
Column Rename< 1 %- Rule Engine< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Python Source (legacy)< 1 %
Variable to Table Row< 1 %- Number to String< 1 %
- Reference Row Splitter< 1 %
- RowID< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date&Time Shift< 1 %
- Table Row to Variable< 1 %
- String Manipulation (Multi Column)< 1 %
- Split Collection Column< 1 %
- Wait...< 1 %
Database Connection Table Reader< 1 %- Java Snippet< 1 %
- Column Merger< 1 %
Row Filter (deprecated)< 1 %- Sorter< 1 %
- Rule-based Row Filter< 1 %
- Math Formula (Multi Column)< 1 %
- R Snippet< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- Modify Time< 1 %
- Mask Date/Time (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
- Column Auto Type Cast< 1 %
- Duplicate Row Filter< 1 %
- Missing Value Column Filter< 1 %
- Normalizer< 1 %
- Missing Value< 1 %
- String to Number (PMML)< 1 %
- Number Rounder< 1 %
- DB Reader< 1 %
- Column Expressions (legacy)< 1 %
- String to Duration< 1 %
- File Reader< 1 %
- Column Appender< 1 %
- Rule-based Row Splitter< 1 %
- Excel Reader< 1 %
- Counter Generation< 1 %
CSV Reader< 1 %Database Reader< 1 %List Files< 1 %- Duration to Number< 1 %
- Date&Time-based Row Filter< 1 %
Variable to Table Column< 1 %- Lag Column< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Empty Table Creator< 1 %
- GET Request< 1 %
- XPath< 1 %
Table Row to Variable< 1 %- Column Combiner< 1 %
- Column Renamer (Dictionary)< 1 %
- String Configuration< 1 %
- Table Editor (JavaScript)< 1 %
- Text Output Widget (legacy)< 1 %
- Extract System Properties< 1 %
- Column Aggregator< 1 %
Column Appender< 1 %- Cache< 1 %
- Time Series Generator< 1 %
- R to Table< 1 %
- Date Field Extractor (legacy)< 1 %
Extract Attribute< 1 %- Column Rename (Regex)< 1 %
- One to Many< 1 %
- Cross Joiner< 1 %
- R Source (Table)< 1 %
- Duration to String< 1 %
- Logistic Regression Learner< 1 %
- Row Filter (Labs)< 1 %
- DB Update< 1 %
Loop End< 1 %Cell Splitter< 1 %String To Number< 1 %- End IF< 1 %
- Dictionary Replacer (File-based)< 1 %
- Time Difference (legacy)< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Column List Loop Start< 1 %
- Linear Regression Learner< 1 %
- Table Validator< 1 %
- Edit Numeric Domain< 1 %
- Equal Size Sampling< 1 %
- Partitioning< 1 %
- Pivot< 1 %
- Number to String (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
- Data Explorer< 1 %
- IF Switch< 1 %
- DB Query Extractor< 1 %
- Line Plot (Plotly)< 1 %
- Java Snippet Row Filter< 1 %
- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Boolean Widget< 1 %
- R Predictor< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Moving Average< 1 %
- Variable to Table Column< 1 %
Loop End (2 ports)< 1 %Recursive Loop End< 1 %- Regression Predictor< 1 %
- Nominal Value Row Filter< 1 %
- Empty Table Switch< 1 %
- Transfer Files< 1 %
- Latitude/Longitude to Coordinate< 1 %
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
- Show all 53 workflows
Links
- Conversion from Unix timestamp to Dateby qqilihq on 2020-03-12forum.knime.com/p/84243
- CSV Data can not seperate between time stamp and valueby mlauber71 on 2019-01-10forum.knime.com/p/52612
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.