Suppose you have column that have data
And this is YYYYMM data and you want to convert it to Date Column.
So first you convert the column to text column
Then append "01" to the end
And change it to Date with
And now order_date column is converted to Date data type column.