SQL Date Conversion

I have a field in my table which is varchar 255, and the date is displayed as 02-Feb-18. I have tried to convert this to DD/MM/YYYY with no success. Does anyone know how this can be completed.
thanks in advance

Well, I think this will do it if you just need to display a string:

select convert(varchar(10),convert(date,yourcolumn),103) from yourtable

1 Like

Thanks Mark, it worked just as I needed.

Lyn Goodman