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, 249🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...