Hi Friend i have small doubt in date format in sql server
in my table having data like
date(dd/mm/year) and datatype is varchar(20)
1/1/2011
10/3/2012
9/8/2010
19/9/2007
9/11/2009
based on above data i need output like
date
01/01/2011
10/03/2012
09/08/2010
19/09/2007
09/11/2009
pleas tell me query how to solve this issuse