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
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select (date) | Yes | The date column to extract from |
Part | Select | Yes | year, month, day, hour, minute, second, dow, week |
SQL generated under the hood
SELECT *, EXTRACT(month FROM order_date)::INTEGER AS order_month FROM dataRelated Operations
- Increment Date - Add/subtract time intervals
- Date Difference - Calculate difference between two dates