{"title":"Date&Time Part Extractor","nodeType":"Manipulator","id":"*Y7HUng9RndjN31qc","factoryName":"org.knime.time.node.extract.datetime.ExtractDateTimeFieldsNodeFactory2","factoryId":"org.knime.time.node.extract.datetime.ExtractDateTimeFieldsNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Extracts specific components from Date, Time, Date&amp;time (Local), or Date&amp;time (Zoned) columns. Appends the extracted values as integer or string columns, depending on the component.\n <br />\n Useful for extracting years, months, days, or time components for analysis, filtering, or visualization.</p>\n        ","shortDescription":"Extracts date and/or time fields from date & time cells.","keywords":["extract","date","time","fields","day","quarter","week","year"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAOxAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAHESURBVDiNhZPBqxJRFMZ/M81IpjiGPDB44qJoF2RELQraRS3EVVDbB0mBf0Grt3LbykVBG2nnppjdEyIIJnn0LKKSF25GKigQSSak0bmnhSPNmxz74HAv557vO9+9nKvxFzpwE7gCmMAb4Bnwmw3QwnXbMIyntVpNqtVqUSllOI7zrd1uZ3zf3wHebxI5kUqlnH6/PxQRsW1bWq2WiIiMRqMfmUzmLXAqiawD95vNplQqldPxw1KptNXpdEzgQWJ70zT3fN/3JUTUwQq5XO51Et/IZrPHTdM0G40Gg8GA8XhMvV4/UmRZlj6dTg1g8Y9COp1+KSKilJIgCCQIAomjUCgkOtBns9lBt9v9oGkauq6j6/qRAtd1v0wmEzfxDYDtfD6/73meF++8WCzm5XL5FXB+kwDAdcuyDmzbfqeUUiIivV7vU7FYdIA7wDngDHAsTlwNUha4AVw1DOOCpmnafD7/CDwEDoG7wGOWU/k5zB0C+1GxXWCH5WzEm1wDfgESCQXcihZuAd+BIfAEeMTyL3wNCcOYwO66t7gIuLHCVXiR/fOVU22NSAa4DVwCTgLT8K428CLkXAZ+rnPwP9wDzkYTfwC6teFcRJe3HwAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"The input table that contains columns with date or time information to extract."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table containing the extracted fields as appended columns."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Date&time column","description":"Select the column containing Date, Time, Date&amp;time (Local), or Date&amp;time (Zoned) values from which you want to extract specific fields.","optional":false},{"name":"Extracted fields","description":"Define date or time fields to extract and their column names.\n<ul><li><b>Field</b> : The type of field to extract.\n  <ul><li><b>Year</b> : Extracts the year as number and appends it as an integer column.</li><li><b>Year (Week-based)</b> : Extracts the year based on the week and appends it as an integer column. Depending on the selected locale, week 1 of a year may already start in the previous year, or week 52 of a year may last until the next year (e.g., 30th Dec 2010 belongs to week 1 of year 2011 (locale en-US), so the extracted <i>Year (week-based)</i> would be 2011 while the extracted <i>Year</i> would be 2010).</li><li><b>Quarter</b> : Extracts the quarter of the year as a number in range [1-4] and appends it as an integer column.</li><li><b>Month (Number)</b> : Extracts the month of the year as a number in range [1-12] and appends it as an integer column.</li><li><b>Month (Name)</b> : Extracts the month of the year as a localized name and appends it as a string column.</li><li><b>Week</b> : Extracts the week of the year as a number in range [1-52] and appends it as an integer column. A partial week at the beginning of a year is handled according to the chosen locale.</li><li><b>Day of Year</b> : Extracts the day of the year as a number in range [1-366] and appends it as an integer column.</li><li><b>Day of Month</b> : Extracts the day of the month as a number in range [1-31] and appends it as an integer column.</li><li><b>Day of Week (Number)</b> : Extracts the day of the week as a number in range [1-7] and appends it as an integer column. The numbering is based on the chosen locale.</li><li><b>Day of Week (Name)</b> : Extracts the day of the week as a localized name and appends it as a string column.</li><li><b>Hour</b> : Extracts the hour of the day as a number in range [0-23] and appends it as an integer column.</li><li><b>Minute</b> : Extracts the minute of the hour as a number in range [0-59] and appends it as an integer column.</li><li><b>Second</b> : Extracts the second of the minute as a number in range [0-59] and appends it as an integer column.</li><li><b>Millisecond</b> : Extracts the millisecond fraction of the second as number in range [0-999] and appends it as an integer column.</li><li><b>Microsecond</b> : Extracts the microsecond fraction of the second as number in range [0-999,999] and appends it as an integer column.</li><li><b>Nanosecond</b> : Extracts the nanosecond fraction of the second as number in range [0-999,999,999] and appends it as an integer column.</li><li><b>Time Zone Name</b> : Extracts the unique time zone name as a non-localized name and appends it as a string column.</li><li><b>Time Zone Offset</b> : Extracts the time zone offset as a localized, formatted number and appends it as a string column.</li></ul></li><li><b>Column name</b> : The name of the column populated with the values of the selected field. The field cannot be empty (it must contain at least one character).</li></ul>","optional":false},{"name":"Locale","description":"The locale that governs the localization of output strings (month, day of week, time zone offset) and takes care of local calendrical characteristics (week and day of week numbering).","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}