select from date_test t
INSERT INTO date_test VALUES(SYSDATE)
INSERT INTO date_test VALUES(to_date('2011-08-09 20:12:11','yyyy-mm-dd hh24:mi:ss'))
select dd from date_test t WHERE SYSDATE BETWEEN dd AND dd+1/24
DECLARE
datevar DATE;
BEGIN
SELECT dd INTO datevar FROM date_test WHERE ROWNUM=1;
dbms_output.put_line(TO_CHAR(datevar,'yyyy-mm-dd'));
END;