Extract Year Month from Date

Extracting Year and Month from a Date

Extracting the year and month from a date can be a useful task in various applications, such as data analysis, reporting, and scheduling. In this article, we will discuss the different methods to extract the year and month from a date in various programming languages and tools.

Using SQL

In SQL, you can extract the year and month from a date using the following methods:

• EXTRACT function: This function extracts a specified part of a date, such as the year or month.
• YEAR and MONTH functions: These functions extract the year and month from a date, respectively.

For example:

SELECT EXTRACT(YEAR FROM date_column) AS year, 
       EXTRACT(MONTH FROM date_column) AS month
FROM table_name;

Or:

SELECT YEAR(date_column) AS year, 
       MONTH(date_column) AS month
FROM table_name;

Using Python

In Python, you can extract the year and month from a date using the datetime module.

from datetime import datetime

date_string = "2022-09-01"
date_object = datetime.strptime(date_string, "%Y-%m-%d")

year = date_object.year
month = date_object.month

print(f"Year: {year}, Month: {month}")

Using Excel

In Excel, you can extract the year and month from a date using the following formulas:

• function: This function extracts the year from a date.
• function: This function extracts the month from a date.

For example:

=YEAR(A1)
=MONTH(A1)

Assuming the date is in cell A1.

Using JavaScript

In JavaScript, you can extract the year and month from a date using the Date object.

let date_string = "2022-09-01";
let date_object = new Date(date_string);

let year = date_object.getFullYear();
let month = date_object.getMonth() + 1; // months are 0-based in JavaScript

console.log(`Year: ${year}, Month: ${month}`);

📝 Note: The getMonth method returns the month as a zero-based value, so we add 1 to get the correct month number.

Conclusion Summary

In summary, extracting the year and month from a date can be achieved using various methods and tools, including SQL, Python, Excel, and JavaScript. By using the appropriate functions and formulas, you can easily extract the year and month from a date and use them in your applications.