DateTime Conversion to Date

Question

I wanted to convert DateTime data which will be pulled 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 ?

Answer 1

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