How to Get the Month from a Date in SQL

How to Get the Month from a Date in SQL

Do you need to extract the month from a date in SQL? It's actually quite simple! With the help of the EXTRACT function, you can easily get the month from a date in SQL.

The Solution

The solution is to use the EXTRACT function. This function takes two arguments: the part of the date you want to extract (in this case, the month) and the date itself. For example, if you wanted to extract the month from the date 2020-03-01, you would use the following query:

SELECT EXTRACT(MONTH FROM '2020-03-01');

This query would return the result 3, since the month of the date is March.

Examples

Let's look at a few examples of how this function can be used. Suppose you have a table called orders with the following data:

order_date
----------------
2020-03-01
2020-04-15
2020-05-20

If you wanted to extract the month from each of these dates, you would use the following query:

SELECT EXTRACT(MONTH FROM order_date) FROM orders;

This query would return the results 3, 4, and 5, since the months of the dates are March, April, and May, respectively.

Additional Info

The EXTRACT function is supported by most major databases, including MySQL, PostgreSQL, and SQL Server. However, the syntax may vary slightly depending on the database you are using. For more information, check out the documentation for your particular database. 🤓