Need getdate to return a Julian date

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jonathan SSC-Insane Points: 20427 More actions · Answer 1



SELECT YEAR(GETDATE())*1000+DATEPART(y,GETDATE())

--Jonathan

RoadRunner SSC-Addicted Points: 409 More actions · Answer 2

SSC-Addicted

Points: 409

November 18, 2003 at 7:05 am

Thank you.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

might also be of interest

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

achoksi SSC Enthusiast Points: 166 More actions · Answer 4

This statement will not work for dates that fall in the year 2000. Which is the best way to do for year 2000?

David Burrows SSC Guru Points: 65142 More actions · Answer 5

How about

cast(year(GETDATE()) as varchar) + 

REPLACE(STR(DATEDIFF(d,cast(year(GETDATE()) as varchar)

 + '-01-01',GETDATE())+1,3),' ','0')

Far away is close at hand in the images of elsewhere.
Anon.

achoksi SSC Enthusiast Points: 166 More actions · Answer 6

SSC Enthusiast

Points: 166

November 19, 2003 at 7:35 am

Thank you

Jonathan SSC-Insane Points: 20427 More actions · Answer 7

quote:
This statement will not work for dates that fall in the year 2000. Which is the best way to do for year 2000?

The statement I posted certainly will; the YEAR() function returns four digits...



declare @d datetime

set @d = '2000-02-15'

SELECT YEAR(@d)*1000+DATEPART(y,@d) -- Returns 2000046

--Jonathan

Calvin Lawson SSChampion Points: 11030 More actions · Answer 8

select datediff(dd, '12-31-' + cast(datepart(yy, getdate())-1 as varchar), getdate())

Signature is NULL