MS SQL: Convert Datetime column to nvarchar

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

This should help. It contains all (or most anyway) the different date formats

http://wiki.lessthandot.com/index.php/Formatting_Dates

I think you'd be better off handling the string conversion in client if possible.

Answer 2

select convert(nvarchar(10), datefield, 103)

Answer 3

Assuming sql server, here is the convert documentation:
http://msdn.microsoft.com/en-us/library/ms187928.aspx

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

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

Answer 4

Geez, I type too slowly...

select CONVERT (NVARCHAR, GETDATE(), 103)

Answer 5

Look up convert in BOL.

Answer 6

Use Convert with the 103 option.