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 colum.
-
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 |
|==