Julian date into our date format

[ravi]

Hello,
anybody has query regarding converting date from Julian into our our dateformat?.
Your Help really apreciated,
Thanks,
Ravi

[mist]

Look in books on line at the CONVERT function.

[MAK]

it depends on what format of Julian date u r talking about

yyddd

tttt.ddd

ddd

History
-------
Julian date based on the number of days since noon, Universal Time on January 1, 4713 BCE. Jan 1, 1900 was Julian date 693596.

[ravi]

finaly,
I have created the function for julain to our calender date.

Here is the function and you can change according to your requirment too.

drop function format_date_julian
go
CREATE FUNCTION format_date_julian
( @inp_date float )
RETURNS DATETIME
AS
BEGIN
declare @strDate varchar(31),
@iYear varchar(31),
@fmt_date datetime

if( @inp_date = 0 or @inp_date is null )
begin
return null
end

select @strDate = cast( @inp_date as varchar(31))

select @iYear = cast(left(@strDate,DATALENGTH(@strDate)-3) as varchar(31))

select @iYear =
CASE DATALENGTH(@iYear)
WHEN 0 THEN '2002'
WHEN 1 THEN '200' + @iYear
WHEN 2 THEN '20' + @iYear
else @iYear
END

select @fmt_date = cast(@iYear as datetime)
select @fmt_date = dateadd(dd,cast(right(@strDate,3) as int) - 1,@fmt_date)

return @fmt_date
end



-- select dbo.format_date_julian(2002)