Generates date&time values, i.e. either a date, a time, a date&time (local) or a zoned date&time. There are three creation modes: Either a number of rows, a starting point, and an ending point is selected (the steps in between will be calculated), or a number of rows, a starting point and an interval is selected (the interval defines the steps between each row), or a starting point, an ending point and an interval is selected (the number of rows corresponds to how often the interval fits between start and end).
Options
Output Settings
Mode Selection
Starting Point
Ending Point
Popular Successors
- Cross Joiner9 %
- Date&Time Shift9 %
- Date&Time Part Extractor8 %
- Date&Time to String7 %
- Joiner5 %
- String Manipulation4 %
- Column Appender3 %
- Column Expressions2 %
- GroupBy2 %
- Date&Time Difference2 %
- Table Row to Variable2 %
- Concatenate2 %
- Constant Value Column2 %
- Duplicate Row Filter2 %
- Rule Engine2 %
- Excel Writer1 %
- Modify Date1 %
- String to Date&Time1 %
Row Filter (deprecated)1 %- Table Row to Variable Loop Start1 %
- Cell Splitter< 1 %
- Date&Time-based Row Filter< 1 %
- Reference Row Filter< 1 %
- Modify Time< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Time Zone< 1 %
- Math Formula< 1 %
- Table Creator< 1 %
Column Rename< 1 %- CSV Writer< 1 %
- Java Snippet< 1 %
- Counter Generation< 1 %
- Rule-based Row Filter< 1 %
Extract Date&Time Fields< 1 %- Loop End< 1 %
- Chunk Loop Start< 1 %
Concatenate (Optional in)< 1 %- Table Transposer< 1 %
- Microsoft SQL Server Connector< 1 %
- Column Filter< 1 %
- Sorter< 1 %
- Legacy Date&Time to Date&Time< 1 %
Table Column to Variable< 1 %CSV Writer< 1 %Column Appender< 1 %Table Row to Variable< 1 %- Table Writer< 1 %
- Column Resorter< 1 %
- Variable to Table Column< 1 %
- Value Counter< 1 %
- Random Matcher< 1 %
- GET Request< 1 %
- Window Loop Start< 1 %
- Variable Creator< 1 %
Cell Replacer< 1 %- String to Path< 1 %
- Create Date&Time Range< 1 %
- Table Column to Variable< 1 %
- Group Loop Start< 1 %
- String Manipulation (Variable)< 1 %
- Parallel Chunk Start< 1 %
- DB Delete (Table)< 1 %
- Send to Power BI< 1 %
- Extract Duration Fields< 1 %
- Date Field Extractor (legacy)< 1 %
- Variable to Table Row< 1 %
String To Number< 1 %- Parquet Writer< 1 %
- DB Reader< 1 %
Excel Sheet Appender (XLS)< 1 %- Columns to JSON< 1 %
Python Script (1⇒1)< 1 %- Date Extractor< 1 %
- Benchmark Start< 1 %
- CSV Reader< 1 %
- Loop End (Column Append)< 1 %
- Add Empty Rows< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- Equal Size Sampling< 1 %
Joiner< 1 %- Rank< 1 %
- RowID< 1 %
- Top k Row Filter< 1 %
- DB Query Reader< 1 %
- DB Table Creator< 1 %
- External Tool< 1 %
- Line Plot (JavaScript)< 1 %
- Python Script (legacy)< 1 %
- R Snippet< 1 %
- Table to R< 1 %
- ARIMA Predictor< 1 %
- Extract Variables (Data)< 1 %
Database Reader< 1 %Database Looping< 1 %- Recursive Loop Start< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Reference Column Splitter< 1 %
- Reference Row Splitter< 1 %
- Shuffle< 1 %
- Rule Engine Variable< 1 %
- Merge Variables< 1 %
- MySQL Connector< 1 %
- Parameterized DB Query Reader< 1 %
- DB Update< 1 %
- DB Writer< 1 %
- TimeDelay Loop Start< 1 %
- Math Formula (Variable)< 1 %
- Interval Chart (JFreeChart)< 1 %
Microsoft Authenticator (Deprecated)< 1 %Excel Writer (XLS)< 1 %- Value Selection Widget< 1 %
- String to Duration< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- ARIMA Visualization< 1 %
- Wait...< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %- Table Reader< 1 %
Table Writer< 1 %Loop End< 1 %- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
Recursive Loop Start< 1 %- Variable Loop End< 1 %
- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- One to Many< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Table Updater< 1 %
- Unpivot< 1 %
- Value Lookup< 1 %
- Rule-based Row Splitter< 1 %
- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Send Email< 1 %
- Color Manager< 1 %
- DB Connector< 1 %
- DB Insert< 1 %
- DB Loader< 1 %
- DB Table Selector< 1 %
- Random Number Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- Time Series Generator< 1 %
- Excel Reader< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Create File/Folder Variables< 1 %
- List Files/Folders< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Date/Time Shift (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Create Collection Column< 1 %
List Files< 1 %- Auto-Binner< 1 %
Number To String< 1 %- Extract Table Dimension< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- Generic Web Service Client< 1 %
Excel Sheet Appender (XLS)< 1 %- Data to Report (BIRT)< 1 %
- Duration to Number< 1 %
- Extract URI Info< 1 %
Variable to Table Column< 1 %- Java Edit Variable< 1 %
Counting Loop Start< 1 %Generic Loop Start< 1 %- Constant Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Data Explorer< 1 %
- Kaplan-Meier Estimator< 1 %
- Timer Info< 1 %
MySQL Connector< 1 %- Random Label Assigner< 1 %
- Bar Chart (JavaScript)< 1 %
- Cell to PMML< 1 %
Excel Writer (XLS)< 1 %- Java IF (Table)< 1 %
- Number Filter< 1 %
- Google Analytics Query (legacy)< 1 %
- Credentials Widget< 1 %
- Time Field Extractor (legacy)< 1 %
- Neo4j Reader< 1 %
- HTTP Retriever< 1 %
Database Connection Table Reader< 1 %Database Writer< 1 %Parameterized Database Query< 1 %Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
- Decision Tree Learner< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Table Validator (Reference)< 1 %
- Partitioning< 1 %
- Numeric Row Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
CASE Switch Data (End)< 1 %- Bubble Chart (Plotly)< 1 %
- Variable Expressions< 1 %
- Math Formula (Multi Column)< 1 %
- Line Chart (JFreeChart)< 1 %
- Excel Cell Updater< 1 %
- Nominal Row Filter Configuration< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Moving Aggregator< 1 %
- XPath< 1 %
- Customer Distributions< 1 %
- Message Slack channel< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- Read Variables< 1 %
- Load text-based files< 1 %
- Python Snippet< 1 %
- List Remote Files (legacy)< 1 %
- String to URI< 1 %
- Upload (legacy)< 1 %
- URI to String< 1 %
- URL to File Path< 1 %
- URL to File Path (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Variable to Table Row< 1 %Database Delete< 1 %Database Table Connector< 1 %Database Update< 1 %Database Table Selector< 1 %Database Connector< 1 %- Extract System Properties< 1 %
File Reader< 1 %Loop End (2 ports)< 1 %- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %Recursive Loop End< 1 %Recursive Loop Start (2 ports)< 1 %Table Row To Variable Loop Start< 1 %- X-Partitioner< 1 %
- Naive Bayes Predictor< 1 %
- K Nearest Neighbor< 1 %
Regression Predictor< 1 %- Regression Predictor< 1 %
- SVM Learner< 1 %
- PCA< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Binner (Dictionary)< 1 %
- Create Byte Vector< 1 %
Cell Splitter< 1 %Linear Correlation< 1 %- Create Table Structure< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Edit Numeric Domain< 1 %
- HiLite Row Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
- Table Difference Finder< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
Rank Correlation< 1 %- Rank Correlation< 1 %
- Statistics< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- Create Temp Dir (legacy)< 1 %
Merge Variables< 1 %- Conditional Box Plot (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Hive Connector< 1 %
- DB Merge< 1 %
- DB Column Filter< 1 %
- DB Row Filter< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Number Assigner (Apache)< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- Numeric Distances< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Index Query< 1 %
- OSM Map View< 1 %
Excel Reader (XLS)< 1 %Send to Power BI< 1 %- External SSH Tool< 1 %
- Java Edit Variable (simple)< 1 %
- Strings to Document< 1 %
- Create Folder< 1 %
- Google Sheets Updater< 1 %
- Value Filter Definition (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Tile View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Container Output (Table)< 1 %
- Table to JSON< 1 %
- Container Output (JSON)< 1 %
Python Script (1⇒1)< 1 %- Python Predictor (legacy)< 1 %
Python Script (2⇒1)< 1 %- Python Source (legacy)< 1 %
- Add Table to R< 1 %
- R Source (Workspace)< 1 %
- R to Table< 1 %
- POST Request< 1 %
- Webpage Retriever< 1 %
- Table Difference Checker< 1 %
- Disturber Node< 1 %
- Duration to String< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Twitter Search< 1 %
- Twitter Timeline< 1 %
- XML Row Combine and Write< 1 %
- RDKit Interactive Table< 1 %
Hash Calculator< 1 %
Views
- This node has no views
Workflows
00 Data GenerationKNIME Hub- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 001 Stock Prediction - Data Access and PreparationKNIME Hub
- Show all 1004 workflows
Links
- Automatically add date and time information to a data column with an exception of databy armingrudd on 2019-05-16forum.knime.com/p/60630
- Get Current Month and last monthby armingrudd on 2019-09-05forum.knime.com/p/69385
- Increase date by loopingby armingrudd on 2019-11-27forum.knime.com/p/75620
- Only update new filesby mlauber71 on 2019-10-04forum.knime.com/p/71735
- Current date formatby armingrudd on 2020-01-11forum.knime.com/p/78535
- Show all 11 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.