We are working with JDE system and get two fields from the table F42199, SLUPMJ (Julian Date) and SLTDAY (time).
We need a timestamp date+time, something like CONCAT(SLUPMJ,SLTDAY) as EventEnd.
which is the best way?
we used this way, but we have some problems
TO_TIMESTAMP(CONCAT(CONCAT(SUBSTR(SLUPMJ,2,5),’ '),SUBSTR(CONCAT(‘0’,CAST(SLTDAY AS VARCHAR)),LENGTH(CONCAT(‘0’,CAST(SLTDAY AS VARCHAR)))-5,6) ),‘YYDDD HH24MISS’,1) AS “date_time_1”
thanks in advance