Hi
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
Lyn
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