Collections:
QUARTER() - Quarter of Year
How to extract the quarter of year from a given date using the QUARTER() function?
✍: FYIcenter.com
QUARTER(date) is a MySQL built-in function that returns the quarter of year from a given date. For example:
SELECT QUARTER('2023-02-03'), QUARTER(NOW()), NOW(); -- +-----------------------+----------------+---------------------+ -- | QUARTER('2023-02-03') | QUARTER(NOW()) | NOW() | -- +-----------------------+----------------+---------------------+ -- | 1 | 4 | 2023-11-15 09:51:50 | -- +-----------------------+----------------+---------------------+
Reference information of the QUARTER() function:
QUARTER(date): int Returns the quarter of the year for date, in the range 1 to 4. Arguments, return value and availability: date: Required. The date to extract the quarter of year from. int: Return value. The quarter of year. Available since MySQL 4.
Related MySQL functions:
⇐ PERIOD_DIFF() - Difference of Year-Month Periods
2023-11-17, 250🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...