I would like to format a date in a table and insert it into a view.
here is a snippet of my select command which contains the date:
UserDefinedData.FieldValue AS DOB
The DOB (date of birth) field currently looks like this:
Is it possible to convert it to something like this:
I tried this:
CONVERT(varchar(10), UserDefinedData.FieldValue, 103) AS DOB,
but it had no effect.