Question: how to convert date format to mm dd yyyy in sql server 2008?
Answer: Use the FORMAT function to format the date and time.
To get DD/MM/YYYY use SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as date.
To get MM-DD-YY use SELECT FORMAT (getdate(), 'MM-dd-yy') as date.
Check out more examples below.