如何以dd / MM / yyyy格式将日期时间转换为日期

I want to write a query to get Date in dd/MM/yyyy format. (I do not want time).I want to write a query to get Date in dd/MM/yy