...
Once the pipeline runs, you will see using the TO_DATE expression string has converted the string to a date object based on the chose format
Note:
For files that have meta data like Excel, if we set the column as date like below
Then EazyDI will be able to infer the column as date or date time and even if we use the TO_DATE function, it will skip it as it only transforms columns which are of string types
