Hello, I hope someone can help / tell me what I am doing wrong!
I have a table column which is formatted to Varchar(8) and contains date information in the format 21151103 (yyyymmdd).
I have been trying to use the following syntax in a SQl View to output this in the date format 03/11/2015.
CONVERT(Varchar(8), DateField, 103) AS DateValue
However, the output is delivered in the same format as the table i.e. 21151103
Many thanks in advance