Collections:
YEAR() - Year of Date
How to extract the year from a given date using the YEAR() function?
✍: FYIcenter.com
YEAR(date) is a MySQL built-in function that returns the year from a given date. For example:
SELECT YEAR('2007-08-09'), YEAR(NOW()), NOW(); -- +--------------------+-------------+---------------------+ -- | YEAR('2007-08-09') | YEAR(NOW()) | NOW() | -- +--------------------+-------------+---------------------+ -- | 2007 | 2023 | 2023-11-15 08:25:19 | -- +--------------------+-------------+---------------------+
Reference information of the YEAR() function:
YEAR(date): int Returns the year for date, in the range 1000 to 9999, or 0 for the “zero” date. Arguments, return value and availability: date: Required. The date to extract the year from. int: Return value. The year of date. Available since MySQL 4.
Related MySQL functions:
⇒ YEARWEEK() - Year Week Combination
⇐ WEEKOFYEAR() - Calendar Week of Year
2023-11-17, 242🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...