Im digging in some java code and I found the following part in the Select part of a SQL definition see attached code, just to get a jul-date from JDE into a ISO date format (YYYYMMDD).
and this is used for each of the date fields in the SQL def.
Is there no other solution then this garbage?
a standard function?
a own written function?
an Include file? whatever
my java knowledege is verry low so please help me with an example.
case when (a.JDAT IS NULL " +
or a.JDAT < 1011) then '0' ELSE " +
(to_char(to_date(to_char((1900 + " +
(100 * TO_Number(substr(to_char(a.JDAT),1,1)))) " +
+ substr(to_char(a.JDAT),2,2)) || '-01-01', 'yyyy-mm-dd') " +
+ (substr(a.JDAT,4,3) - 1), 'yyyymmdd')) END JDAT, " +