You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kylin.apache.org by 洪陆驾 <ho...@iwalnuts.com> on 2016/06/03 08:49:47 UTC

What is the function to get last day?

hi:
What is the function to get last date (or last N day)?  


my SQL is something like *where FACT_DATE_ID = date_sub(curdate(), interval 1 DAY);*


I found calcite 1.7.0 has support TIMESTAMPADD, TIMESTAMPDIFF functions, is it will be help? But Kylin only support calcite 1.6.0 now.