How do I convert a datetime column to nvarchar with the format DD/MM/YYYY?

Question

I need to select a datetime column in a table. However, I want the select statement to return the datetime as a nvarchar with the format DD/MM/YYYY.

Answer 1

Here is the convert documentation:

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql

Looking through that, it looks like you want style 103:

SELECT CONVERT(nvarchar(10), getdate(), 103)