Great MySQL Date Functions to Know
Below the video are great date functions on MySQL. However, you can first witness a two-minute video that joins a MySQL table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query.
You can now download our books on Synapse, Redshift, Google BigQuery, DB2, Oracle, Yellowbrick, Vertica, MySQL, Postgres, and more for FREE.
You can download the PDFs from our CoffingDW.com website immediately.
Here is how you do it. Go to CoffingDW.com and click on Books from the top right menu. You will then be in the CoffingDW bookstore, where you will see the Snowflake book. Add the Snowflake book to your cart.
Add any book you want to your cart.
When you check out, you use the coupon FRIEND2023.
You won’t have to enter any credit card information. Just put in your name and email, and the price will be discounted to zero. You can then download the book immediately at no cost to you.
The current_date will return today’s date. Add or subtract a number from the CURRENT_DATE, and you are adding or subtracting days from the date. For example, subtracting from two dates, you get the number of days between the two dates. Notice we performed the cast function to get the dates in a proper format when doing addition or subtraction.
Below are the keywords you can utilize to get the date or timestamp. These are reserved words that the system will deliver to you when requested.
You can use the DATE_ADD function to add or subtract days from a date.
The below examples show how robust the EXTRACT command is at extracting portions of a date, time, or timestamp.
You can use the dayname and monthname to find the day of the week and the month spelled out.
The DATE_FORMAT function formats a date as specified in the argument through specifiers. The percent sign % is required before each format specifier.
Below are several formats of the order_date. These basics will help shape your knowledge of formatting dates.
The DATE_SUB function will subtract a time value (as an interval) from a date.
The DATEDIFF function returns the number of days between two dates or datetimes. This function only calculates the date portion from the expressions.
The DAYNAME function returns the name of the weekday of a date specified in the argument (Sunday, Monday, Tuesday).
The examples below show you how to use day, month, and year intervals.
Tom Coffing, better known as Tera-Tom, founded Coffing Data Warehousing, where he has been CEO for the past 30 years. Tom has written over 90 books on Architecture, performance tuning, and SQL on all relevant systems. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus, which celebrates 20 years of brilliantly integrating all databases.
