Just a note of caution when using the date format styles - 103 will give you dd/mm/yyyy whereas 101 will give you mm/dd/yyyy...
select convert(varchar,convert(datetime,'20050910'),103) as UKDate
select convert(varchar,convert(datetime,'20050910'),101) as USDate
**ASCII stupid question, get a stupid ANSI !!!**