4 ms·
Two ways to address this: - Join to a date dimension and coalesce nulls to 0 - use RANGE BETWEEN (only available in some DBs) on a date_difference column
by artwr 6y ago
Two ways to address this:
- Join to a date dimension and coalesce nulls to 0
- use RANGE BETWEEN (only available in some DBs) on a date_difference column