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.