kylin日付関数処理

リファレンスhttp://kylin.apache.org/cn/docs/tutorial/sql_reference.html
CAST RANGE , INTERVAL  キーワードは範囲を示します.PRECEDING  先日(秒/分/時/月/年)を表します.FOLLOWING  次の日(秒/分/時/月/年)を表します.例: 

SELECT part_dt, lstg_format_name, SUM(price) AS gmv, FIRST_VALUE(SUM(price)) OVER (PARTITION BY lstg_format_name ORDER BY CAST(part_dt AS timestamp) RANGE INTERVAL '3' DAY PRECEDING) AS "prev 3 days", LAST_VALUE(SUM(price)) OVER (PARTITION BY lstg_format_name ORDER BY CAST(part_dt AS timestamp) RANGE INTERVAL '3' DAY FOLLOWING) AS "next 3 days" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;

select CAST(DISCHARGE_TIME AS timestamp)  from BI.CDR_PAT_ADT_EXTERNAL  where DISCHARGE_TIME < '2018-11-04' and DISCHARGE_TIME >= '2018-11-03' ;