Returns the quarter of the year in which a date or datetime expression occurs.
QUARTER(dExpression | tExpression [, nMonth])
- Specifies the Date expression for which you want QUARTER(В ) to return a value.
- Specifies the DateTime expression for which you want QUARTER(В ) to return a value.
- Specifies an optional starting month to the examined quarter. You can use this to specify quarters based on a fiscal rather than a calendar year.
Numeric data type. QUARTER( ) returns the quarter of the year in which a date occurs, and the values can be 0, 1, 2, 3, or 4.
QUARTER(В ) returns 0 if passed an empty Date or DateTime value, for example, |