Multiple date conversions in one field.
I have source date column having the data in the form of DD-MM-YYYY, YYYY.MM.DD and MM/YYYY/DD format.
What I want to do is I want to integrate them into one format.
So please guide me first how to differentiate which records have following
You can use the string functions to find -,.,/ based on which you can differentiate them using a case transform and them use to_date or to_char to convert into system format or your given format.