convert one date type format to DDMMYYYY
I have a source column datatype as date and target also date .
my source date column is in dd.mm.yyyy format and i wanted to change to ddmmyyyy format in target .
Db used here is MSsql
i have tried many options and nothing is working.