{"title":"Time Rounder","nodeType":"Manipulator","id":"*7phhn81u4VasQR1D","factoryName":"org.knime.time.node.manipulate.datetimeround.TimeRoundNodeFactory","factoryId":"org.knime.time.node.manipulate.datetimeround.TimeRoundNodeFactory","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Rounds time columns to a specified granularity. You can adjust time values using user-defined rounding strategies and precision and either replace or append the rounded values to the input table.\n <br />\n Commonly used to round times to the nearest minute, hour, or other time units for aggregation or reporting.</p>\n        ","shortDescription":"Rounds a time.","keywords":["modify","ceil","floor","truncate","fields","hour","minute","second","millisecond","precision","day","weekday","month","quater","decade","week","date"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAACXBIWXMAACE4AAAhOAFFljFgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAi7SURBVHgBxVprbBTXFT531uuY3XVxwCF2/Wxjgylps+smyhY/2P6oGugPqHg4iVrZxg1R1QJOq0YYI8VIWEArpbihUlUF23mhAI5kosTmByR+xV4SBTshJCS7gSU4wiTGgth4Ye2dyT3XO7N3Zmdf3iV8kr1n7uzMnO+exz33zBJIMhx2eyEYidXvlzL4cYOBXAf/rKdn8IMRSCIIJAhHud0hisIqiUgOIoGVDmVEvYiQEZCkXkGQOnsGnD2QAOZFwOFwZIi3b1dLAqyjSjsgMXiACE0+v7/X6XR6IE7ETaBipb2GAPk3hJnprOxsKCoqBovFohofG7sCU1NT4Ha5wt3aQ9Vp7xsc3A1xIGYC6Nt+A2nTzjgqWl5RCbbSUvpZAZb09Ij3mZqcBLfbBd1dXTBy5gwlNqb9iscnSr+O1RoxEagsK6sGSTwA3Kyj4hurqmDDxk1RlY6EE11vQ9uhQzpESFMs1ohKoHLlyucApCZ+rLauLmHFtdAlIsGBvqGhZyJdF5GAVvmsrCxo3rcfioqLw14jiiJ4vbdgZmYGut9+i/r9JAiCAaqeeJxaLTLhsStXoLFhhypOJBoX/YODtRAvAa3yVlspNO/dqzvrV6avwofjH8EyoQjI7eAtn/3bdrg2Ps7kIx1vsACPBe2th5g1YiGRojeImYZXfvWaNbCjcZdyfmr2JvSPDYHru4swcHWIEvgGMo2L4F8PxJVAwqJmcx37lEkQkGrohHr0YiKEAGYbcS5NMpRXVjLlx7xX4ejFN2Hk2lmq+IWQh5aYwrvVfIAkJmna7ThyJDAiNZXb7b0DTvXCJ2gvxFQJgWyDPt+ws5GNZy24H6ZmpnSVR9gsv4BkY+u27dR1bcqxIJA2XET576gIsEWKy/MtB/+r8vmdDz0D1kU/131YiTm5FpDRQK3PLYqFou9WPX9eRYBI5DlZrqUm1AZd/1UnjEycBS1KTEVgEhbAnQDqgGmb03I7bwWFAAtcAoXsIuo6j9HA5YEx8J9z/9d9SF5aLtxJbNhUxbtSBm+FoAUIqZbF1Wt+FzL7rV8cpiS+YbKcccoWPsqOS++A/2uhtYIsMQKYeXjf187+MM083aOnlOOtOVsYiT9l/4Epn+wMpAdch7hYyKAZyYECI+AXgspjQaad/TbXYUUup7Oen5ajHG/NfQp+KGygtZcMmpHWsU92xLlPBc37PND30QIy1maugbsFG5dSKdbiP0YgsJNiKCpeqrqIVx6zDbrO3YLGjQoxGwmBlMTSEp7UFmr9Y05FLltoh7sN3r39Pt8qAWZvcbMfGoxY58jIvycH7jbUOor3CtEucE8GS4f8O5zvY0FWVtACtO4tFPzi3OKlPZlstLUeYvviZCOqBRJBZuZ9inyC7oGr1q+Hvc17kkpEAIk2nALA3VMkTIteiAebtzwNZRXqtIxE6qqrWa0f7XmxQPAT4pEPdDoEtIxeosjjvmsQD9ACm596GvY/fwCWlSxXxrG9gruuupoa1p2IB9jRkCHRDoaQKoqKBXBPqoVtcbB8Pu91wXyARJ7duYuRWZyZCfzz9lGXqtqwPmYi2JaRIYmUQM9c/4WRwJnRkij60U8VeXjyLCQCdKd/Pt8SlkhdTXWkxhcDfz4lLW3EgEJ+Xp6dpqQSlDETrXjwQeVLBZY8eO3LDiaPz0ywWshkMEEiyC8ogN/8djVNgwTGx78F7/Q0G5+YmIA3OztZkBcvLQ7pYowMn2HnA/D09g/sZwQKcnOyCSGPoezz+Vg5LSPVkMo2MXIp7aWBXJqenPJ52fLlYPvlw+yely9cUsZxljuOHmUydvxkHKNjn547x2Taqej86vLl4yyNGiTSGWQ5HJIdaoufVOSBG6fh/PT8YkEPLND/uIUFujZj8cqzZ/f38YdMZ2YBz+jo9fzcPAcJ7MhSU+9RXZxtul9lhc8pAbRCoq7Ew2QyM2sgCewlWW1W2LgpWD5jkJ8IBrqnf3DozyjwC1mLLHQcPRJihZ0P1YMlxcxkjIUXvn6RfsaXVmMBWqT+7/+Av/x1m2oc064CCRSPMcjCV6Oj5wty83BfnIFx4PPNwKP2YPVpMVpgxb0lys7sxux3MDz1ccKWwMXRSIyqsZwfZ4PZHLynZvbBJ0lPjFKvURFA0Gx0ibrR4yhjsODmZtHixcp5dKV0oxlOf3tGefh7NCaMghEeWFAI8Sk+DV3XTsLLY6+rJmHJkvvAbAp2ODAj7WtuZil+DtLu94acoRZAoBX4WHj/9GnWVsSYkIFWyDYtYS0WxIw0C5/c/IwRQSVMhgURLSIr/r+v2+EsvQ4n4XOvG3618GEoyMkDi1l9beMOVbOXthedv+fPhzR3WWtRIMMQ2ORgOwMbXFrgVnPrUIMS2Dyw7M5MWUTbLTkBpb3g9Xtp9nLrxg02yxqt9az7xwMr2HauySvSFx/a1qJud7rCTjt0AmsxMmCXooFr7vI4dvE47Zke1yUSDZgUapc+CZt+sjbknFZ5dB06+03a7xn0bkxdaaQgL5eSIw48RhO6XV+woObdCYEuhQqgW03O3IxKBJX+WUYJbFuxhf3xtZaMF1pa4PCrr/BDLVT5HXr3i/KCw95Ev6K0G3E/2nLwYMSND7beXTcuMBfjt6NIEOsqTARyOtYCA3bvnj1sMVUgSS/1DTlrwj0vhldMahIIbH2rO2WJ4xhde9pbW1XVZjTlEQaIgkuXR3toZrpBMxMuCmk4hjN0oruLFVvp6Zaor47CARfLUydPwS76WumdkydZHcZpv5sqXx/tHnG9ZhUJeVduAPPAIK+gJYC11BaVDCrtdrmhv6+XTkK3esbn4KHZplabbcJhfi+6sQ2vQwSBbQ/sL2njhCnudutumgKgK6vUIqSmHejp6bkOMWLev5UIvLHHLrEVEsO8FJeR8I89Vj7yiDXFaFgnSWQVjRNHjJfhL1Z6qat0xuoq4ZAwAS2QkGAwZBBB42K0++GfnfWkms2e+cx0OHwPqK6VsHeOL8cAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing date&amp;time columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with rounded times."}],"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 columns","description":"The date&amp;time columns whose values are shifted.","optional":false},{"name":"Round to","description":"The rounding strategy to apply, either round to the first, last or nearest value of the chosen rounding precision.\n<ul><li><b>First point in time</b> : Rounds to the first point in time of the selected duration. E.g., rounding 18:45.215 to one hour yields 18:00.</li><li><b>Last point in time</b> : Rounds to the last point in time of the selected duration. E.g., rounding 18:45.215 to one hour yields 19:00.</li><li><b>Nearest point in time</b> : Rounds to the nearest point in time of the selected duration. E.g., Last/First is chosen depending on which one is closer to the to be rounded time</li></ul>","optional":false},{"name":"Rounding precision","description":"The rounding precision. The date will be rounded to the first or last value of the chosen precision. Represented as a duration, i.e., PT1H for one hour.","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","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":[]}