SQL

how to extract year from date in sql

SELECT EXTRACT(YEAR FROM '2018-07-22')
Code language: SQL (Structured Query Language) (sql)

how to extract only year and month from date in sql

SELECT FORMAT(<your-date-field>,"YYYY-MM") AS year-date FROM <your-table>

sql get month and year from date

DECLARE @date date = '04-18-2020' --date for act;
SELECT YEAR(date), MONTH(date)    --, DAY(date) add if u want day

sql date with month and year only

SELECT
   DATEADD(MONTH, DATEDIFF(MONTH, 0, <dateField>), 0) AS [year_month_date_field]
FROM
   <your_table>

Extracting month from date column in SQL

SELECT Name,
MONTH(ProducedDate) AS ProducedMonth
FROM Furniture;