Date/Time ISO 8601 Parts

Description

Splits a date/time field into two or columns according to the ISO 8601 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 ISO year and by ISO week to get Hire DateIsoYear and HireDateIsoWeek.