CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

condition to compare the Julian date

edited Oct 27, 2019 5:07AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered

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

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