如何用sql插入data类型的变量啊！

Question

SQL> select * from test1;        ID ZYZ1                    P1 DOCTIME
---------- --------------- ---------- -------------------
        24 dfdf
        23 df0SQL> insert into test1 (doctime) values(to_date('2002-05-01 10:12','yyyy-mm-dd hh24:mi:ss'));1 row created.SQL> commit;Commit complete.SQL> select * from test1;        ID ZYZ1                    P1 DOCTIME
---------- --------------- ---------- -------------------
        24 dfdf
        27                            2002-05-01 10:12:00
        23 df0

Answer 1

to_date('2002-8-20','yyyy-mm-dd')即可

Answer 2

insert into mytab(mydate) values (to_date('2002-08-20 15-20-10','yyyy-mm-dd hh24-mi-ss');

Answer 3

SQL> declare 
  2    i date;
  3  begin
  4    i :=sysdate;
  5    insert into test1 (doctime) values(i);
  6  end;
  7  /PL/SQL procedure successfully completed.SQL> select * from test1;        ID ZYZ1                    P1 DOCTIME
---------- --------------- ---------- -------------------
        24 dfdf
        27                            2002-05-01 10:12:00
        28                            2002-08-20 15:22:27
        23 df0