Returns the day of the month of a date value as a number.
Category: date
Syntax:
Day([date_column], |timezone|)
IntColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
date_column | column|datetime | ✓ Yes | The date from which to extract the day component. |
timezone | text | ✗ No | Optional IANA time zone name (e.g., “Europe/Amsterdam”). |
Validation
- Minimum parameters: 1
- Maximum parameters: 2
Examples
Returns the day of the month of each date value in the [Date] column as a number. Last modified on March 13, 2026
