MySQL QUARTER() Function

The name of the pictureThe name of the pictureThe name of the pictureClash 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


-