SQL Server code to convert JDEdwards Julian Dates to dates / formatted strings From http://sqlfiddle.com/#!3/d41d8/28945

JDEJulianDatesInSQL.sql

declare @JulianDate integer = 114026;
select DATEADD(day,@JulianDate%1000-1,CAST(cast(@JulianDate/1000 + 1900 as varchar(4)) + '-01-01' as date)) ActualDate

--take the result calculated above into a variable
declare @ActualDate date --could use datetime if desired
set @ActualDate = DATEADD(day,@JulianDate%1000-1,CAST(cast(@JulianDate/1000 + 1900 as varchar(4)) + '-01-01' as date))

--format it however you fancy (see http://www.w3schools.com/sql/func_convert.asp)
select CONVERT(nvarchar(24), @ActualDate, 113)