获取当前时间
SELECT
*
FROM ADM_JR_CUSTOMER_CREMINDER_DI
where to_char(CREATION_TIME,'yyyy-mm-dd') = 当前时间
now()
--------
where to_char(CREATION_TIME,'yyyy-mm-dd') = '${today()}'
-------------
公式:today()或now()
select *
from table
where 时间字段=${today()}
where to_char(CREATION_TIME,'yyyy-mm-dd') = to_char(sysdate,'yyyy-mm-dd')
这样写。