From other source I am getting a data as string format like 'Sep 6 2013'. I want to see it as a Date format.
and the date format should be DD/MM/YYYY.
It means 'Sep 6 2013' looks like 06/09/2013.
Is it possible to to that in SQL server?