sql server - SQL convert 'DDMMYY' to datetime

Question

I am trying to convert a date from DDMMYY format to datetime in SQL Server.

I am using the convert command as follows

select convert (datetime, '311012', <style>)

I have tried looking on msdn for the supported styles but haven't found an exact match.

Help will be much appreciated.

Answer 1

select convert (datetime,  Stuff(Stuff('311012',5,0,'.'),3,0,'.'), 4)