Quarterly Data Syntax

I am trying to build a query that will return what quarter the data is in.
How would I begin to build this logic? In my table, all I have is a single
date of the transactions. My date column looks like this; "2014-02-01
00:00:00.000".

Thanks in advance,

Ryan

Ryan,

To get the quarter, assuming January to March is the first quarter"

select (datepart(Month,MyDateColumn) + 2) / 3

This depends on how integer match works. Or you can create a calendar table
(Google for that) to record this kind of information for every date.

RLF


"Ryan Mcbee" wrote in message

>I am trying to build a query that will return what quarter the data is in.
> How would I begin to build this logic? In my table, all I have is a
> single
> date of the transactions. My date column looks like this; "2014-02-01
> 00:00:00.000".
>
> Thanks in advance,
>
> Ryan