This guide will help you learn how to convert strings into time values.

Inputs

Please, note that the format of the input time fields should be as follows: HH:MM:SS.

           

Other variations are also possible:

           

           

However, in these cases the date prefix will be truncated.

Configuration

To start using the To Time function,

1. Configure data sources and provide the mapping
   
   
   
   
2. Open the Transform node
3. Switch to the Functions tab
4. Click on the Date and Time section to find the To Time icon
5. Drag-and-drop it to the Transformation's work panel
   
   
   
   
6. Map the input and output fields according to the picture below
   
   
   
   
7. Press Ok to close the window

Preview

Now you can preview the results. To do so, right-click on the Tranform or output node.

           

The preview window will pop up.