Dates to quarters

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

Try researching DATEPART(quarter, DATEx) in BOL....

Good Hunting!

Mike-238404 Old Hand Points: 353 More actions · Answer 2

Thanks!

SELECT TYPE,vendor,discontinueddate, datepart(quarter, GETDATE()) AS 'Quarter'

from EOL

WHERE (DISCONTINUEDDATE >= '01/01/2005')

Order by discontinueddate

works and returns the Current quarter but how do I change the GETDATE to cover all years 2005 and above?

Mike-238404 Old Hand Points: 353 More actions · Answer 3

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

from EOL

WHERE (DISCONTINUEDDATE >= '01/01/2005')

Order by Discontinueddate

Works!!!

Mike-238404 Old Hand Points: 353 More actions · Answer 4

what if I need the quarters always 24 months from today everyday?

I tried using the DateAdd("m",24,Now());

But no luck

Hints??

sara karasik SSCommitted Points: 1573 More actions · Answer 5

use getdate() instead of now(). and no need to quote the mm

select DateAdd(mm,24,getdate())

sushila SSC-Dedicated Points: 35293 More actions · Answer 6

or..just to take the tedium out of all this...

select DateAdd(yy, 2, getdate())

**ASCII stupid question, get a stupid ANSI !!!**