How can I use sysdate in apache drill

Question

I want to run this query through Apache Drill.

select * from mytable where  my_date BETWEEN sysdate-1280 AND sysdate;

Answer 1

select * from mytable 
where  my_date BETWEEN DATE_SUB(CURRENT_TIMESTAMP, interval '1280' day(4))
AND CURRENT_TIMESTAMP;