Remove time stamp from date

Jul 24 2013 5:17 AM

Hi, I have a column in a SQL database which displays the date each record was created but the field not only shows the date but also the time. I want to remove the time stamp so only the date is shown in the table ( Like this 24/07/2013 not like this 24/07/2013 00:00:00). The column name I am trying to convert is called Date_Recieved.
I'm sure there is a simple solution to this problem and thank you for your help in advance.

Answers (2)

Join multiple tables

Sql query