DateTime Conversion to Date

I wanted to convert DateTime data which will be pul开发者_运维技巧led from source, to Date format only or I want to retrieve only Date with no time. How is it to be done here ? Also how is to be done for converting the Datetime data for a customised format while pulling from the source ?

Stripping the time was discussed here. Could you possibly use a similar method?

Also...

Refer BOL --> Convert

print convert(varchar(10),getdate(),101)

print convert(varchar(10),DateTimeCol,101)

courtesy of Srinika