Summary for Date and Time Functions
Summarize the key insights you’ve explored about date and time functions in MySQL.
We'll cover the following...
The SQL function CAST() is a means to cast a value of any type to a value of a specified target data type. With this, CAST() is also able to modify temporal values. This way of using CAST() to modify values of temporal data types works reasonably well for basic use cases. For example, casting a value of type DATE to a value of type YEAR extracts the year of the given date. The result is equivalent to applying the SQL function YEAR() to a DATE. However, we cannot accomplish more involved use cases using the CAST() function. ...