Julian Date

[EPNICO]

Hello:

I need to find out if Sybase or MSSQL7.0 has some way to convert a date to a julian date?

Thanks

 

[tlbroadbent]

There are many definitions of "Julian Date." The following links should help.

Sybase function:

http://manuals.sybase.com/onlinebooks/group-iq/iqg1121e/iq_admin/@Generic__BookTextView/10955

Here are some T-SQL queries that return various forms of the Julian date.

-- Julian in format yyddd

Declare @jd char(5)
Select @jd=
right(Convert(char(4), year(getdate())),2) +
right('00'+convert(varchar(3),datepart(dd,getdate())),3)
Print @jd

-- Julian date in format tttt.ddd

Declare @jd char(7)
Select @jd=
Convert(char(4), year(getdate())) + '.' +
right('00'+convert(varchar(3),datepart(dd,getdate())),3)
Print @jd

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

Select @jd=DATEDIFF(D,'1/1/1900',getdate())+693596
Print @jd Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm