Text to Date/Time
Description
Converts a string to a date/time.
The date format will be: MM/DD/YYYY.
Refer to Notes on Conversions for more details on how Data Prep Studio converts text to date/time.
INPUT/Output DATA TYPE
Input |
Output |
text |
date/time |
example
In this example, Hire Date is the original column and Hire Date - Converted shows the converted values.