George McMullen
SELECT ID, TranID, Type, TranDate FROM Transaction WHERE TranDate >= TO_DATE( TO_CHAR ( SYSDATE, 'DS' ), 'DS' ) AND TranDate < TO_DATE( TO_CHAR ( SYSDATE + 1, 'DS' ), 'DS' )