Date field format from 100605 to 10/06/05

[dwight1]

Hi All,

I have a DTS that transfers data from AS400 to SQL server. The date format is 100605 or 80605. I want this to be changed to 10/06/05 and 8/06/05 respectively or any other date format at the time of transfer or after transfer.

Any ideas please.

Dwight

 

[DrSql]

http://www.tek-tips.com/viewthread.cfm?qid=1118673&page=1

Dr.Sql
Good Luck.

 

[dwight1]

Thank you!