Convert Julian Dates in SQL SERVER

  • SQL SERVER JULIAN TO DATE (WHEN DOWNLOADING JULIAN DATE)
  • date field has to be nvarchar or varchar or character.
  • declare @DateP char(10)

    select @datep=107277 — ALSO OK FOR 99 YEARS

    select
    dateadd(dd,@datep-(@datep/1000)*1000-1, convert(datetime,’01/01/’+ right(convert(varchar,@datep/1000),2))) as Date_ENT