AnsweredAssumed Answered

How to format date from query to gel script for XOGing

Question asked by urmas on Apr 6, 2017
Latest reply on Apr 21, 2017 by urmas

How to format date from query to gel script for XOGing?

I am running a standard query in Oracle for project data in a gel script and getting

start="2017-10-18 08:00:00.0” and passing that to xml file content fro XOGing.

 

The XOG fails because it wants the date  like

start="2017-10-18 08:00:00.0”

 

I could manipulate that with db date formats and manipulate the result with sql and  in gel to get the right format.

Before doing that just wanted to know how others are doing that?

Is there an Oracle date format which is directly compatible with the required format for XOGing without any manipulation?

 

Did not see any related posts with a quick search.

Outcomes