Date/Time Into Parts
Description
Splits a date/time field into two or columns according to the date/time components you select.
Input/Output Data Type
|
Input |
Output |
|
date/time |
number |
Example
In this example, Hire Date is the original date/time column. We split this column into 2 columns by year and by month to get Hire DateYear and Hire DateMonth.
© 2024 Altair Engineering Inc. All Rights Reserved.