A. The SQL date/time field stores a date and time but if you have a populated table and you want to convert a column so it lists data only run the following:
update <table>
where <column>=convert(datetime,convert(char(10),<column>,101))
For example
update faq
where created=convert(datetime,convert(char(10),created,101))