 | This guide will help you learn how to convert strings into date values. |
Function configuration
To start using the To Date function,
- Configure data sources and provide the mapping
- Open the Transform node
- Switch to the Functions tab
- Click on the Date and Time section to find the To Date icon
- Drag-and-drop it to the Transformation's work panel
- Map the input and output fields according to the picture below
- 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.
Examples
The following examples show how date and time patterns are interpreted in the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone.
| Date and Time Pattern |
Result |
| "yyyy.MM.dd G 'at' HH:mm:ss z" |
2001.07.04 AD at 12:08:56 PDT |
| "EEE, MMM d, ''yy" |
Wed, Jul 4, '01 |
| "h:mm a" |
12:08 PM |
| "hh 'o''clock' a, zzzz" |
12 o'clock PM, Pacific Daylight Time |
| "K:mm a, z" |
0:08 PM, PDT |
| "yyyyy.MMMMM.dd GGG hh:mm aaa" |
02001.July.04 AD 12:08 PM |
| "EEE, d MMM yyyy HH:mm:ss Z" |
Wed, 4 Jul 2001 12:08:56 -0700 |
| "yyMMddHHmmssZ" |
010704120856-0700 |
| "yyyy-MM-dd'T'HH:mm:ss.SSSZ" |
2001-07-04T12:08:56.235-0700 |
- Press Ok
- 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.
