MySQL QUARTER() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL QUARTER() Function
❮ MySQL Functions
Example
Return the quarter of the year for the date:
SELECT QUARTER("2017-06-15");Try it Yourself »
Definition and Usage
The QUARTER() function returns the quarter of the year for a given date value (a number from 1 to
4).
- January-March returns 1
- April-June returns 2
- July-Sep returns 3
- Oct-Dec returns 4
Syntax
QUARTER(date)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date or datetime to extract the quarter from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the quarter of the year for the date:
SELECT QUARTER("2017-01-01 09:34:21");Try it Yourself »
Example
Return the quarter of the year for the date:
SELECT QUARTER(CURDATE());Try it Yourself »
❮ MySQL Functions
