oracle_日期

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;