📅
Intermediate About 20 min
Date & Time Functions
Use EXTRACT, DATE_TRUNC, AGE, and interval arithmetic for time-series grouping and tenure calculations.
What you'll learn
- Extract date parts (year, month, day) with EXTRACT
- Truncate dates to a period with DATE_TRUNC for time-series grouping
- Calculate durations with AGE and date subtraction
- Format dates for display with TO_CHAR
- Use INTERVAL for date arithmetic