support:
add_sub/add day,week,month,year,quarter
eg:
select row_id,DATE_SUB(L_SHIPDATE,INTERVAL 2 day)  from LINEITEM WHERE
DATE_SUB(L_SHIPDATE,INTERVAL 2 DAY)= '1998-11-27' order by row_id;