These did not work. I was hoping to change the sysdate to the Julian date.

The Sysdate for my application displays as "22-NOV-24" in Oracle SQL Developer queries.

When using the options from the first comment:

TO_NUMBER (TO_CHAR (SYSDATE, 'J')) TO_JULIAN -- Resulted in 2460637 on November 22, 2024, so this does not work

TO_DATE (2457259, 'J') TO_GREGORIAN -- Resulted in 24-AUG-15 on November 22, 2024, so this does not work

It looks like this question still needs some work with an answer that actually works.