Query untuk Detail tanggal dan waktu

Dari query sbb:

SELECT COUNT (*) FROM BODES_SUBSCRIPTION WHERE NEXT_RENEWAL between to_date('20100719 000000','YYYYMMDD HH24MISS')and to_date('20100719 235959','YYYYMMDD HH24MISS') AND SUBSCRIPTION_STATUS = 'ACTIVE'

Supaya menjadi otomatis mengeluarkan query perhari, maka querynya diubah menjadi sbb:

SELECT COUNT (*) FROM BODES_SUBSCRIPTION
WHERE NEXT_RENEWAL
between trunc(sysdate) and trunc(sysdate+1)
AND
SUBSCRIPTION_STATUS = 'ACTIVE'