If at all there is a choice, you should change the data type of the Customer_date column to DATE or DATETIME. That would be beneficial for a number of reasons.
That aside, if you want to keep it as varchar(50), you can convert teh long format to the mm/dd/yyyy format using this:CONVERT(VARCHAR(50), CAST( 'Feb 25 2013 12:00:00' AS DATETIME),101)
saving date as varchar in the date format
Posted - 02/08/2013 : 12:30:59
