Julian Date Conversion - DB2 Export -> SQL Server

I have a date field called SDDQRJ which stores dates in 5 digit Julian form yyddd. so 01214 is the 214th day of year 01. any idea how to a conversion of this date to say mm/dd/yyyy using sql or vb script. I am trying to implement this conversion in DTS module of SQL Server. Thanks.
timokeeffeAsked:
Who is Participating?
 
SqueebeeCommented:
Is this question properly places by beingin the MySQL area? You refer to DB2 and MSSQL. While MySQl might serve your needs well I think you have posted this question in the wrong area.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.