[ https://issues.apache.org/jira/browse/CALCITE-5495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-5495. ---------------------------------- Fix Version/s: 1.33.0 Resolution: Fixed Fixed in [b8ccac15|https://github.com/apache/calcite/commit/b8ccac153a5be6db72fcbcbda983a83d40b7932b]; thanks for the fix, [~tanclary]! > Allow WEEK and QUARTER in INTERVAL literals > ------------------------------------------- > > Key: CALCITE-5495 > URL: https://issues.apache.org/jira/browse/CALCITE-5495 > Project: Calcite > Issue Type: Bug > Reporter: Julian Hyde > Priority: Major > Fix For: 1.33.0 > > > Allow interval literals denominated in weeks and quarters, for example: > {code} > INTERVAL '1' WEEK > INTERVAL '2' WEEKS > INTERVAL '3' QUARTERS > INTERVAL '4' QUARTER > {code} > Week intervals have type {{INTERVAL DAY}} (a week is 7 days); quarter > intervals have type {{INTERVAL MONTH}} (a quarter is 3 months). -- This message was sent by Atlassian Jira (v8.20.10#820010)