QUARTER
Syntax
QUARTER(<date>)
Description
Returns the quarter of the year for the supplied date in a range from 1 to 4.
Defined Quarters | |
---|---|
Quarter | Months |
1 | January, February, March |
2 | April, May, June |
3 | July, August, September |
4 | October, November, December |
Examples
Date | QUARTER Returns |
---|---|
Jan 06, 2018 12:23:05 | 1 |
Apr 06, 2018 12:23:05 | 2 |
Jul 06, 2018 12:23:05 | 3 |
Oct 06, 2018 12:23:05 | 4 |