Add 'Week' to interval options

In DuneSQL, interval '1' week does not work. The suggested workaround is to use '7' day, but this also causes datatype failures in the following code (where time granularity is an input - we want calendar months, so '30' day does not suffice) ``` CASE WHEN '{{Time Period}}' = 'week' THEN interval '7' day WHEN '{{Time Period}}' = 'day' THEN interval '1' day WHEN '{{Time Period}}' = 'month' THEN interval '1' month END ```

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

Feature Requests

Date

About 3 years ago

Author

Michael S

Subscribe to post

Get notified by email when there are changes.