Extract Date Part

Extract year, month, day from a date

What It Does

Extract Date Part pulls out a component of a date column as a number. Get the year, month, day, hour, minute, second, day of week, or week number.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Extract Date Part". It's in the Date group.

Configuration

FieldTypeRequiredDescription
ColumnColumn select (date)YesThe date column to extract from
PartSelectYesyear, month, day, hour, minute, second, dow, week

SQL Generated

SELECT *, EXTRACT(month FROM order_date)::INTEGER AS order_month FROM data
Try this operation →

Notes

  • Null values are handled gracefully - operations skip or preserve nulls where appropriate.
  • You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
  • The SQL preview shows exactly what will execute - inspect it before applying.

Related Operations