• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2266
  • Last Modified:

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.
0
timokeeffe
Asked:
timokeeffe
1 Solution
 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now