sql - 在雪花中使用间隔文字处理别名
问题描述
我有一个这样的查询:
select to_date(current_date - interval 'b.a day') as date from (select 1 as a) as b
预期结果应该是间隔“1 天”,然后将计算日期之间的差异。相反,它会引发以下错误:
SQL compilation error: syntax error line 1 at position 0 unexpected 'b'.
解决方案
只要您只需要日期/日期,您实际上就可以简化它:
select to_date(current_date()) - b.a as date from (select 1 as a) as b;