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

Function configuration

To start using the To Date 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 Date 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. To set the format of the input date fields, double-click on the To Date node and enter the format. (Please see the table below to learn more.)
   
   
   
   Input date format settings:
   
   

   Letter	Date or Time Component	Type	Examples
   G	Era designator	Text	AD
   y	Year	Year	1996; 96
   M	Month in year	Month	July; Jul; 07
   w	Week in year	Number	27
   W	Week in month	Number	2
   D	Day in year	Number	189
   d	Day in month	Number	10
   F	Day of the week in month	Number	2
   E	Day in week	Text	Tuesday; Tue
   a	am/pm marker	Text	PM
   H	Hour in day (0-23)	Number	0
   k	Hour in day (1-24)	Number	24
   K	Hour in am/pm (0-11) format	Number	0
   h	Hour in am/pm (1-12) format	Number	12
   m	Minute in hour	Number	30
   s	Second in minute	Number	55
   S	Millisecond	Number	978
   z	Time zone	General time zone	Pacific Standard Time; PST; GMT-08:00
   Z	Time zone	RFC 822 time zone	-0800

   Please note that all parameters in the "Letter" field are case sensitive.

8. Press Ok
9. Close the Transformation window

Now you can preview the results or continue data integration.

Preview

To check the results, right-click on the Tranform or output node.

           

The preview window will pop up.