SSIS Julian to Gregorian date conversion

benjie

Member
Dear All,

Need help on how to use SSIS to convert julian date to gregorian date. For example, julian 112001 to gregorian 01/01/2012.

My JDE input table has julian date and want to convert to gregorian into an output table (non-JDE) using SSIS.

Thanks in advance.

Benjie
E9.0, TR8.98, SQL2008
 
Attached is what JDEList offered a couple of years ago.
 

Attachments

  • 175359-Convert julian_conventional date.zip
    1.6 KB · Views: 186
Back
Top