Day / Temporal Layer
Extract day of month from date/datetime values, similar to datetime.day in Python or DAY() in SQL. Returns integers from 1 to 31, depending on the month.
Example extractions:
| Date | Day | Note |
|---|---|---|
| 2024-01-01 | 1 | Month start |
| 2024-02-29 | 29 | Leap year February |
| 2024-04-30 | 30 | 30-day month end |
| 2024-12-31 | 31 | 31-day month end |
Common applications:
- Monthly reporting
- Billing cycles
- Schedule planning
- Payment processing
- Event scheduling
Table
0
0
Table
Transforms
[, ...]Select
columnDate/datetime column to extract day from. Valid days depend on month and year (for February in leap years). Returns the calendar day of month.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.