本帖最后由 maoweiting 于 2012-9-24 09:50 编辑
SQL> create table A
2(RYBH VARCHAR2(8) NOT NULL ,
3 RYMC VARCHAR2(20),
4 SJ DATE,
5 NR VARCHAR2(40));
Table created
SQL>insert into A values('00000001','CYZ',to_date(sysdate,'yyyy-mm-dd hh:mi:ss'),null);----你不会是这样插滴吧?
insert into A values('00000001','CYZ',to_date(sysdate,'yyyy-mm-dd hh:mi:ss'),null)
ORA-01861: literal does not match format string
SQL>insert into A values('00000001','CYZ',sysdate,null)
2;
1 row inserted
SQL> insert into A values('00000001','CYZ',to_date('2012-9-24 9:30:10','yyyy-mm-dd hh24:mi:ss'),null);
1 row inserted
SQL> select sysdate from dual;
SYSDATE
-----------
2012/9/24 9
SQL> select * from A
2;
RYBH RYMC
SJ
NR
-------- -------------------- ----------- ----------------------------------------
00000001 CYZ
2012/9/24 9
00000001 CYZ
2012/9/24 9
|