Converting unix date

[meldrape]

Hello,

I have a text file with three date fields in this format:
yymmdd

How would I go about converting these date formats to mm/dd/yyyy to insert into a SQL table?

Thanks in advance.

 

[meldrape]

Nevermind, I used select CAST ( ENDDATE AS datetime) as ENDDATE from JobImportHeader.

It converts the date to mm/dd/yy but I really need mm/dd/yyyy. If anybody know how to do this, I would appreciate your input. Thanks.