aritting
Active Member
CREATE FUNCTION dbo.JulianToDate(@InJulian numeric(18,0))
RETURNS char(10)
AS
BEGIN
DECLARE @strDate char(10)
set @strDate = convert(char(10),dateadd(day,convert(int,right(@InJulian,3)),'01/01/'+left(right(@InJulian,5),2))-1,101)
RETURN @strDate
END
RETURNS char(10)
AS
BEGIN
DECLARE @strDate char(10)
set @strDate = convert(char(10),dateadd(day,convert(int,right(@InJulian,3)),'01/01/'+left(right(@InJulian,5),2))-1,101)
RETURN @strDate
END