Julian and Gregorian Conversion Functions

/*
Usage examples -
DECLARE
@Date datetime,
@Julian int

SET @Date = '2004-08-03'

SELECT @Julian = dbo.getJulian(@Date)
SELECT @Julian

SELECT dbo.getGregorian(@Julian)
*/

CREATE FUNCTION getJulian (@Date datetime)
RETURNS INT
AS
BEGIN
DECLARE @Julian int

SELECT @Julian =   CAST(CAST(DATEPART(YEAR, @Date)AS char(4)) + '000' AS int)
+ DATEPART(dayofyear, @Date)
RETURN(@Julian)
END
GO


CREATE FUNCTION getGregorian (@Julian int)
RETURNS DATETIME
AS
BEGIN
DECLARE @Date datetime

SELECT @Date = DATEADD(DAY, substring(cast(@Julian as char(7)),5,3) - 1, '01/01/' + substring(cast(@Julian as char(7)),1,4))

RETURN(@Date)
END
GO