Convert Julian Date to Gregorian Date using an SQLServer script or Excel function

sv800

Active Member
I need an SQLServer script to display julian dates as gregorian dates:
(may using CAST and CONVERT)

Eg: 129142 (stored in database)
output: 5/22/2029

Excel function may work to.

Thanks for any help
 
Okay,
here is a sample using lot expiration date of F4108

select iommej as JulianDate,
convert(varchar,cast('1/1/'+cast(left(right(iommej+1000000,6),3)+1900 as varchar) as datetime)+
(right(iommej,3)-1),103) as GregorianDateDDMMYY
from proddta.f4108

where iommej is julian date format
 
Back
Top