condition to compare the Julian date
very new in JDE in DB2 enviornment. I used to be oracle database developer.
asking for recommendation on the best way to compare date in JDE in DB2 ( iSerial )
I got a task to write a simple SQL....
select *
FROM REITPYDTA9.F1501B NE
where ne.nevred > curdate()
As you all know, Date in JDE is in julian. What is the best way to write this where condition? Should I convert them to 'YYYY-DD-MM" format on both side to compared? or covert both side as Julian?? or other better way
thanks