https://www.w3schools.com › Sql › func_mysql_date.asp

Learn how to use the DATE () function to extract the date part from a datetime expression in MySQL. See syntax, parameter values, examples and technical details.

https://dev.mysql.com › doc › refman › 8.0 › en › date-and-time-functions.htm

Learn how to manipulate temporal values with MySQL functions. See the syntax, description, and examples of each function, such as DATE_ADD(), DATE_FORMAT(), NOW(), and more.

https://dev.mysql.com › doc › refman › 8.4 › en › datetime.html

Learn the characteristics, formats, ranges, and conversions of the DATE, DATETIME, and TIMESTAMP data types in MySQL. See how to use CAST() with the AT TIME ZONE operator to convert TIMESTAMP values to UTC DATETIME values.

https://sql.sh › fonctions › date-heur

Apprenez à utiliser les fonctions SQL pour manipuler les éléments temporels en MySQL, PostgreSQL, SQL Server et d’autres bases de données. Trouvez les synonymes, les formats, les exemples et les différences entre les fonctions de dates et d’heures.

https://pcaboche.developpez.com › article › mysql › fonctions-date-heure

La fonction DATE() extrait la partie "date" d'un champ DATETIME (ou d'un champ DATE !). Elle a été introduite avec MySQL 4.1.1. Il est possible de pallier son absence en faisant un simple DATE_FORMAT(expr, "%Y-%m-%d").

https://dev.mysql.com › doc › refman › 8.4 › en › date-and-time-types.html

Learn how to use the DATE, TIME, DATETIME, TIMESTAMP, and YEAR data types in MySQL 8.4. See the range, format, and conversion rules for each type, as well as the special behavior of TIMESTAMP and DATETIME.

https://www.mysqltutorial.org › mysql-date-functions

MySQL Date Functions. This page shows you the most commonly used MySQL Date functions that allow you to manipulate date and time data effectively. Section 1. Getting the current Date & Time. This section explains the functions that allow you to retrieve the current date, time, or both.

https://www.mysqltutorial.org › mysql-basics › mysql-datetime

MySQL DATETIME data type allows you to store a value that contains both date and time. When you query data from a DATETIME column, MySQL displays the DATETIME value in the following format: 'YYYY-MM-DD HH:MM:SS' Code language: SQL (Structured Query Language) (sql) When you insert a value into a DATETIME column, you use the same format. For example:

https://www.mysqltutorial.org › mysql-basics › mysql-date

MySQL DATE is one of the five temporal data types used for managing date values. MySQL uses yyyy-mm-dd format for storing a date value. This format is fixed and it is not possible to change it. For example, you may prefer to use mm-dd-yyyy format but you can’t.