RE: Convert Julian Date to Gregorian Date using an SQLServer scri

RE: Convert Julian Date to Gregorian Date using an SQLServer scri

Sergio, I hope this script helps you.........

select wmupmj as JulianDate,
convert(varchar,cast("1/1/"+cast(left(right(wmupmj+1000000,6),3)+1900 =
as
varchar) as datetime)+ (right(wmupmj,3)-1),103) as GregorianDDMMAADate =
from
testdta.f3111

...where wmupmj is any table field where there is a date storaged as =
Julian
Date...

Regards...
Dorian





Technical Consultant