Search titles, descriptions, headings, and excerpts. Query text stays in this browser; analytics records length and result/click metadata.
Enter at least two characters.
The DAYOFMONTH() is a MySQL function that returns the day of the month for a given date. This can be useful for extracting the numeric day from a DATE or DATETIME value in a query.
DAYOFMONTH()
Install PostgreSQL on Debian 10 legacy systems. Debian LTS ended in 2024; this guide links to the current Debian 13 installation guide.
The DAYNAME() function in MySQL returns the name of the weekday for a given date. It can be useful for formatting dates and timestamps.
DAYNAME()
Install PostgreSQL 18 on CentOS Stream 9 with its AppStream module, initialize the cluster, and start the service. CentOS Stream 9 ends May 31, 2027.
The DAY() function in MySQL is used to get the day of the month from a date value. It returns the day number (1-31) for the given date.
DAY()
Install PostgreSQL on CentOS Stream 8 for legacy systems. Updates ended in May 2024; see CentOS Stream 9 for a maintained CentOS guide.
The DATEDIFF() function in MySQL is used to calculate the difference between two dates in terms of a specified unit like days, weeks, months etc.
DATEDIFF()
Install PostgreSQL on CentOS Linux 8 for legacy systems. CentOS 8 reached end of life in December 2021; see CentOS Stream 9 for a maintained CentOS guide.
The DATE_SUB() function in MySQL is used to subtract a time/date interval from a date and return the new date. It is an alias for the SUBDATE() function.
DATE_SUB()
SUBDATE()
Install PostgreSQL on CentOS Linux 7 for legacy systems. CentOS 7 reached end of life in June 2024; see CentOS Stream 9 for a maintained CentOS guide.