Timezone Conversion

Parent Previous Next


Timezone Conversion Transform


The "Timezone Conversion Transform" easily converts a date from one Timezone to another using the IANA TZ Database.



 Original Timezone / Converted Timezone

o   Source - Select where the original Timezone data will be found. This can be one of three types

  Static Value

  Variable

  Column

o   Enter Static Value / Variable, Input Column - Depending on where the source is stored, you will use this text box to point to the source.

 Source and Output

o   Data Source Column - The column from which the original date will be retrieved from. This column must be a date type.

o   Output Action Where the converted data will be sent. There are two options.

 Output To A New Column - In this mode, a new column name will be given in the "Output Column" textbox, and then you will choose the output data type in the "Column Type" drop down.

 Replace Source Column - In this mode, a source data column will be chosen to replace its value upon conversion.