sgpg
Sammy
Hello,
not sure if this is the right forum for a JDE SQL question but I can be told if wrong!
I have to convert a julian date and I am using the example below
Decode(PRODDTA.F03B11.RPDDJ,
0,
Null,
To_Date(To_Char(PRODDTA.F03B11.RPDDJ + 1900000), 'yyyyddd')) As "Due Date", this converts a Julian (117001 to 01-Jan-17) but I need this to be 20170101 (1st January 2017 UK.
thanks
not sure if this is the right forum for a JDE SQL question but I can be told if wrong!
I have to convert a julian date and I am using the example below
Decode(PRODDTA.F03B11.RPDDJ,
0,
Null,
To_Date(To_Char(PRODDTA.F03B11.RPDDJ + 1900000), 'yyyyddd')) As "Due Date", this converts a Julian (117001 to 01-Jan-17) but I need this to be 20170101 (1st January 2017 UK.
thanks