SYSDATE[
^] function returns the current system date and time on your local database. If you want to extract the date portion only (and reject the time part), you should use the
TO_CHAR()[
^] function. For example:
SELECT dp.*
FROM gb.dpacnt dp
WHERE TO_CHAR(DP.OPENEDDATE,'yyyy/mm/dd') BETWEEN TO_DATE ('2003/08/13', 'yyyy/mm/dd') AND TO_CHAR(SYSDATE, 'yyyy/mm/dd')