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.