OR on the same thought

turn the date into a USA format date (style 12) YYMMDD

declare @mmddyy char(6)

set @mmddyy = '081709'

select CONVERT(varchar(35),CAST(RIGHT(@mmddyy,2) + LEFT(@mmddyy,4) AS DATETIME),112)