Date/Time to Number
Description
Converts a date/time value to number.
Refer to Notes on Conversions for more details on how Data Prep Studio converts date/time to number.
INPUT/Output DATA TYPE
Input |
Output |
date/time |
number |
example
In this example, Hire Date is the original column and Hire Date - Number shows the converted values.