Integration Technologies - JDE1 (MOSC)

MOSC Banner

Orchestrator - Groovy, formatting results of SQL fetch

edited Feb 23, 2021 4:46PM in Integration Technologies - JDE1 (MOSC) 2 commentsAnswered

In an Orchestrator Connector making a SQL call and returning JDE Julian dates in my row, how do I format these to MM/DD/YY using "import java.util.Date", The dates need to be formatted before putting into a JSONarray.

def rows = sql.rows("SELECT SDDCTO,SDTRDJ,SDPDDJ,SDADDJ,SDCNDJ,SDIVD,SDLITM,SDDSC1,SDUORG,SDSOQS,SDUOM,SDNXTR FROM DVDTA.F4211 WHERE SDDOCO=${OrderNum} and SDDCTO=${OrdType}");

I appear to be struggling with the syntax.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center