framework/resources/Functional/datetime/datetime1.q

select cast(c_date as date), date_add(cast(c_date as date),-1) from basic;