Get part of date
The Get part of date step extracts the specified time unit (day of week, day of month, month, year, hours, minutes, seconds, milliseconds) from a date column.
Parameters
-
Input column: required, select a date column from the column list.
-
Part: required, the time unit to be extracted from input date. Following options are available:
-
day of week
-
day of month
-
month
-
year
-
hours
-
minutes
-
seconds
-
milliseconds
-
-
Target column: required, configure the column which will receive the output. Output will always be an integer.
-
Write result to the current column: outputs data into the Input column.
-
Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed next to the Input column.
-
Examples
Sample date: 2023-05-09 03:11:00
| Date unit | Result |
|---|---|
Day of week |
2 |
Day of month |
9 |
Month |
5 |
Minute |
11 |
Returned values
The values returned by the step depend on the selected unit:
| Unit | Minimum value | Maximum value | Note |
|---|---|---|---|
day of week |
1 |
7 (Sunday) |
Value of 1 always means Monday and 7 is Sunday regardless of the start day of the week. |
day of month |
1 |
31 |
|
month |
1 |
12 |
|
year |
292278994 (292 million) |
-292278994 (-292 million) |
Dates can store exact date and time millions of years in the past or in the future. |
hours |
0 |
23 |
24-hour format is used regardless of the display format of the input date column (i.e. 4pm will return 16). |
minutes |
0 |
59 |
|
seconds |
0 |
59 |
|
milliseconds |
0 |
999 |