**Performance Tips:**

- Functions on date columns in WHERE break indexes

- Use date ranges: WHERE date >= '2024-01-01' AND date < '2025-01-01'

- Index date columns used in filtering

- Avoid EXTRACT() in WHERE clause

- Store UTC, convert to local in application layer

Functions on date columns break indexes

Use ranges: date >= '2024-01-01' AND date < '2025-01-01'

Index date columns for fast filtering

Avoid EXTRACT() in WHERE clause

Using TIMESTAMP without timezone (causes bugs)

Functions in WHERE: YEAR(date) = 2024 breaks index

Not handling DST transitions

Comparing dates across timezones without conversion

Integer division in date calculations