Extract The Year From A Date

Return the year component from a date or timestamp value.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Read the year from a launch date

The output is the same year number even though the extraction function differs.

MySQL MariaDB PostgreSQL

Engine-specific syntax

Source table data

Setup

CREATE TABLE products (launch_date DATE);

INSERT INTO
  products (launch_date)
VALUES
  ('2022-07-15');

Validated query

SQL

SELECT
  EXTRACT(
    YEAR
    FROM
      launch_date
  ) AS launch_year
FROM
  products;

Expected result

launch_year
2022

SQL Server

Engine-specific syntax

Source table data

Setup

CREATE TABLE products (launch_date DATE);

INSERT INTO
  products (launch_date)
VALUES
  ('2022-07-15');

Validated query

SQL

SELECT
  YEAR (launch_date) AS launch_year
FROM
  products;

Expected result

launch_year
2022

SQLite

Engine-specific syntax

Source table data

Setup

CREATE TABLE products (launch_date DATE);

INSERT INTO
  products (launch_date)
VALUES
  ('2022-07-15');

Validated query

SQL

SELECT
  CAST(strftime ('%Y', launch_date) AS INTEGER) AS launch_year
FROM
  products;

Expected result

launch_year
2022

SQL Server uses `YEAR()` while the others can use `EXTRACT(...)` in this example.

Useful when

Where this command helps.

grouping data by reporting year
filtering or labeling rows by the year portion of a date

Explanation

What the command is doing.

Date-part extraction is common in reporting and grouping queries. The exact function differs by engine, so this command uses per-engine SQL while keeping the result aligned across all engines.

Extract The Year From A Date

Read the year from a launch date

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.