Returns the quarter of the year in which a date or datetime expression occurs.
QUARTER(dExpression | tExpression [, nMonth]) |
Parameters
- dExpression
- Specifies the Date expression for which you want QUARTER(В ) to return a value.
- tExpression
- Specifies the DateTime expression for which you want QUARTER(В ) to return a value.
- nMonth
- 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.
Return Value
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.
Note: |
---|
QUARTER(В ) returns 0 if passed an empty Date or DateTime value, for example, QUARTER({//}) .
|