Hub
NodeNode / Manipulator

Modify Time Zone

Other Data Types Time Series Manipulate Streamable
Drag & drop
Like
Copy short link

Modifies date&time columns in three different ways. The node can add a time zone to local date&time columns or changing the time zone in zoned date&time columns (without adjusting the time!) or shift the time zone in zoned date&time columns by adjusting the time (and potentially date) according to the new time zone offset or remove the time zone from zoned date&time columns.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table with modified columns.

Extension

The Modify Time Zone node is part of this extension:

Related workflows & nodes

  1. Check Daylight Saving when modifying Time Zone
    This workflow showcases that Modify Time Zone node accurately takes into account Dayligh …
    ipazin > Public > 2019_08_01_Modifying_Time_Zone_Check_Daylight_Saving
  2. 2019_01_04_RemoveZoneAndTime
    iris > Public > 02_ForumExamples > 2019_01_04_RemoveZoneAndTime
  3. NHL Schedule For Specific Team
    Sports GET JSON
    Simple APi query of the National Hockey League API doucmented here https://github.com/eru…
    walkergv77 > Public > OIlers Schedule
  4. Manipulating Date&Time Values
    Data manipulation ETL Data transformation
    +9
    This workflow shows examples of the following operations on date and time values: - Conve…
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 06_Manipulating_Date_and_Time_Values
  5. COVID
    rafaelfre > Public > Youtube > COVID
  6. Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    knime > Examples > 09_Enterprise > 01_Server > 03_Using_KNIMEServer_REST_API > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  7. Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    rolandburger > Public > KNIME Server > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  8. Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    arnaud_heitzman > Public > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  9. Google Big Query meets SQLite. The business of baseball games.
    Databases Google Big Query Big Query
    +7
    This workflow graphically explores attendance at baseball games together with weather con…
    knime > Examples > 01_Data_Access > 02_Databases > 10_GoogleBigQuery_meets_SQLite
  10. API Covid-22
    rafaelfre > Public > Youtube > API Covid-22