TO_DATE(string,’format’) 将一和字串转换为ORACLE的日期。如:Insert into demo(demo_key,date_col) Values(1 , to_date(’04-Oct-1999’, ‘DD-Mon-yyyy’) );
insert into reg_hm_12590 (HM,DJRQ) values ('xiaoli',to_date('20050113201424','YYYY-MM-DD HH24:MI:SS'));
--orinsert into reg_hm_12590 values('xiaoli',to_date('20050113201424','yyyymmddhh24miss'));--orinsert into reg_hm_12590(hm,djrq) select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;--or insert into reg_hm_12590 select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;
insert into reg_hm_12590 (HM,DJRQ) values ('xiaoli', to_date('20050113201424','YYYYMMDDHH24:MI:SS'));
Values(1 , to_date(’04-Oct-1999’, ‘DD-Mon-yyyy’) );
select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;--or insert into reg_hm_12590
select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;
to_date('20050113201424','YYYYMMDDHH24:MI:SS'));