Converts the time values in the timestamp column into string using the selected or entered conversion pattern as defined by SimpleDateFormat. Examples:
- "yyyy.MM.dd HH:mm:ss.SSS" parses dates like "2001.07.04 12:08:56.000"
- "yyyy-MM-dd'T'HH:mm:ss.SSSZ" parses dates like "2001-07-04T12:08:56.235-0700"
- G: era designator
- y: year
- M: month in year
- w: Week in year
- W: week in month
- D: Day in year
- d: day in month
- F: Day of week in month
- E: day in week
- a: Am/pm marker
- H: hour in day (0-23)
- k: hour in day (1-24)
- K: hour in am/pm (0-11)
- h: hour in am/pm (1-12)
- m: minute in hour
- s: Second in minute
- S: millisecond
- z: Timezone (General time zone)
- Z: RFC 822 time zone
Options
Popular Predecessors
Joiner10 %- Time Field Extractor (legacy)3 %
- Date/Time Shift (legacy)3 %
- Date&Time to legacy Date&Time3 %
Cell Splitter2 %- Column Filter2 %
- GroupBy2 %
- Java Snippet (simple)2 %
Number To String2 %- String Manipulation2 %
File Reader2 %- Sorter2 %
CSV Writer2 %String To Number2 %- Time to String (legacy)2 %
Flow Variable IF Switch2 %- String to Number2 %
- Duplicate Row Filter2 %
- Joiner2 %
- Reference Row Filter1 %
Excel Reader (XLS)1 %- Time Difference (legacy)1 %
- Time Generator (legacy)1 %
- Unpivot1 %
CSV Reader1 %Database Reader1 %Table Reader1 %- Column Combiner1 %
Column Rename1 %- Math Formula1 %
- Date&Time to String1 %
- String to Date&Time1 %
- String to Date/Time (legacy)1 %
- Number to String1 %
- Create Date&Time Range1 %
- Modify Time Zone1 %
- Column Splitter< 1 %
- Mask Date/Time (legacy)< 1 %
- Modify Date< 1 %
- File Meta Info (legacy)< 1 %
Table Column to Variable< 1 %Parameterized Database Query< 1 %- Constant Value Column< 1 %
- Timer Info< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Table Creator< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Database Connection Table Reader< 1 %Database Looping< 1 %- Concatenate< 1 %
Concatenate (Optional in)< 1 %- Column Auto Type Cast< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Missing Value< 1 %
- String Replacer< 1 %
XLS Reader< 1 %- Legacy Date&Time to Date&Time< 1 %
- Double to Integer< 1 %
- IF Switch< 1 %
- Empty Table Creator< 1 %
Excel Reader (XLS)< 1 %- CSV Reader< 1 %
- Column Expressions< 1 %
- Excel Reader< 1 %
- Split Collection Column< 1 %
Variable to Table Column< 1 %- Java Snippet< 1 %
Loop End< 1 %- Numeric Binner< 1 %
Column Appender< 1 %- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Cross Joiner< 1 %
Row Filter (deprecated)< 1 %- Pivot< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
Document Data Extractor< 1 %Strings To Document< 1 %- Image Generator< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Average< 1 %
- Preset Date/Time (legacy)< 1 %
- TIBCO Spotfire File Reader< 1 %
Recursive Loop End< 1 %- Case Converter< 1 %
- Column Renamer (Dictionary)< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
- Missing Value (Apply)< 1 %
- Shuffle< 1 %
- DB Reader< 1 %
- TimeDelay Loop Start< 1 %
- Date&Time Configuration< 1 %
- Boolean Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Duration to String< 1 %
- String to Duration< 1 %
- Moving Aggregator< 1 %
- Top k Row Filter< 1 %
- Numeric Outliers< 1 %
Excel Reader (XLS)< 1 %- List Files/Folders< 1 %
- Column Filter (legacy)< 1 %
- String Input (legacy)< 1 %
Views
- This node has no views
Workflows
01_Model_FactoryKNIME Hub- 03_Applying_Text_and_Network_Analysis_Techniques_to_ForumsKNIME Hub
- Applying_Text_and_Network_Analysis_Techniques_to_ForumsKNIME Hub
- CV_BuilderNodePit Space
- CV_BuilderKNIME Hub
- Show all 8 workflows
Links
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.