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, 245🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...