Extract date parts

sql

SELECT
  EXTRACT(YEAR FROM created_at) AS year_num,
  EXTRACT(MONTH FROM created_at) AS month_num
FROM orders;

Explanation

Useful for grouping and reporting by calendar parts.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Date and Time Functions

Return the current date and current timestamp.

Open In sheetsqlsame section

Shift a date or timestamp forward or backward.

Open In sheetsqlsame section

Remove the time portion from a timestamp.

Open In sheetsqlsame section

Roll up metrics by calendar day.

Open In sheetsql1 tag match

Join multiple strings into one value.

Return different values based on conditions.