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 DATE_FORMAT() function in MySQL is used to format a date value based on a specified date/time format string. This allows formatting dates in different ways.
DATE_FORMAT()
Install and verify MariaDB from Ubuntu 22.04 (Jammy Jellyfish)’s APT repositories, enable the service, and create a database user.
The DATE() function in MySQL is used to extract the date part from a datetime expression. It returns the date in ‘YYYY-MM-DD’ format.
DATE()
Legacy MariaDB installation guide for Ubuntu 20.04 Focal. Standard support ended in May 2025; Ubuntu Pro ESM may cover existing hosts through 2030.
The DATE_ADD() function in MySQL is used to add a time/date interval to a date and return a new date. It is an alias for the ADDDATE() function.
DATE_ADD()
ADDDATE()
Legacy MariaDB installation guide for Ubuntu 18.04 Bionic. Standard support ended in May 2023; Ubuntu Pro ESM may cover existing hosts through 2028.
The CURTIME() function in MySQL returns the current time in ‘HH:MM:SS’ format. It is useful for inserting and comparing against the current time.
CURTIME()
Install MariaDB on Rocky Linux 9 with DNF, secure the service, and create a least-privilege database account.
The CURRENT_TIMESTAMP() function in MySQL returns the current date and time as a timestamp value. It is useful for inserting records with the current timestamp.
CURRENT_TIMESTAMP()
Install MariaDB on Rocky Linux 8 with DNF, enable and secure the service, and create a restricted application user.