SQL> select * from tempuser.testtable a where a.recordnumber>90;
RECORDNUMBER CURRENTDATE NAME
------------ ----------- --------------------
91 2008-12-12 abcs
92 2008-12-12
93 2008-12-12 ddd
94 2008-12-12 123
95 2008-12-12
96 2008-12-12 7-3-9
97 2008-12-12
98 2008-12-12 08-09-01
99 2008-12-12 2008-11-12
100 2008-12-12
101 2008-12-15 sdsdd
11 rows selected
SQL> desc tempuser.testtable;
Name Type Nullable Default Comments
------------ ------------ -------- ------- --------
RECORDNUMBER NUMBER(4)
CURRENTDATE DATE
NAME VARCHAR2(20) Y 在以上中,怎么取出日期大于08年1月1日的那些记录
RECORDNUMBER CURRENTDATE NAME
------------ ----------- --------------------
91 2008-12-12 abcs
92 2008-12-12
93 2008-12-12 ddd
94 2008-12-12 123
95 2008-12-12
96 2008-12-12 7-3-9
97 2008-12-12
98 2008-12-12 08-09-01
99 2008-12-12 2008-11-12
100 2008-12-12
101 2008-12-15 sdsdd
11 rows selected
SQL> desc tempuser.testtable;
Name Type Nullable Default Comments
------------ ------------ -------- ------- --------
RECORDNUMBER NUMBER(4)
CURRENTDATE DATE
NAME VARCHAR2(20) Y 在以上中,怎么取出日期大于08年1月1日的那些记录
2 RETURN NUMBER
3 IS
4 val DATE;
5 BEGIN
6 val := TO_DATE (NVL (parmin, 'a'), 'yyyy-mm-dd hh24:mi:ss');
7 RETURN 1;
8 EXCEPTION
9 WHEN OTHERS
10 THEN
11 RETURN 0;
12 END;
13 /Function created.
SQL> select is_date('a') from dual;IS_DATE('A')
------------
0SQL> select is_date('2004-05-05') from dual;IS_DATE('2004-05-05')
---------------------
1SQL> select is_date('2004/01/01') from dual;IS_DATE('2004/01/01')
---------------------
1SQL> select is_date('01/01/04') from dual;IS_DATE('01/01/04')
-------------------
1SQL> select is_date('01-jan-04') from dual;IS_DATE('01-JAN-04')
--------------------
1
按hdhai9451上面的改改就可以了呵呵.