It will depend on how the application chose to compute a their version of a Julian date.
For example, in JDE their date was CYYDDD where C = Century YY = 2 digit year DD = the 3 digit number representing the day of the year (1 through 365 or 366 days on a leap year)
Hence, knowing what the system does will influence what expression you would use.
i.e. an ORACLE user might use this.
to_date(to_char(1900 + floor(DATE / 1000)),'YYYY') + mod(DATE,1000) - 1
if an ORACLE user was using the ORALCLE J-date (days since January 1, 4712 BC) they might use to_date( number-to-string( Julian_Date), 'J')
and so on.
------------------------------
NIGEL CAMPBELL
------------------------------