Collections:
DAYOFMONTH() - Day of Month
How to extract the day of month from a given date using the DAYOFMONTH() function?
✍: FYIcenter.com
DAYOFMONTH(date) is a MySQL built-in function that returns the day of month from a given date. For example:
SELECT DAYOFMONTH('2023-02-03'), DAYOFMONTH(NOW()); -- +--------------------------+-------------------+ -- | DAYOFMONTH('2023-02-03') | DAYOFMONTH(NOW()) | -- +--------------------------+-------------------+ -- | 3 | 22 | -- +--------------------------+-------------------+
Reference information of the DAYOFMONTH() function:
DAYOFMONTH(date): int Returns the day of the month for date, in the range 1 to 31, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero day part. Arguments, return value and availability: date: Required. The date to extract the day of month from. int: Return value. The day of month. Available since MySQL 4.
Related MySQL functions:
⇒ DAYOFWEEK() - Day of Week (1=Sunday)
2023-11-17, 240🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...