------解决方案-------------------- to_char 函数
------解决方案-------------------- update tablename set fldtime=to_date('2010-02-14 14:00:00','YYYY-MM-DD H24:MI:SS') where .....
------解决方案-------------------- select * from tablename where fieldname = '¶meter' for update
------解决方案-------------------- 没太懂楼主的意思:
1、select * from tablename where ....for update 手动修改之。。。 2、update tablename set colname=to_char(sydate,'YYYY-MM-DD HH12:MI:SS' ) where ...
commit;
------解决方案--------------------
------解决方案--------------------
------解决方案--------------------
SQL code
create table timetest
(
timetest date
);
insert into timetest select to_date('2010-01-01 10:11:12','yyyy-mm-dd hh24:mi:ss') from dual;
------解决方案--------------------
SQL code
nsert into table
select to_date('2010-02-21 9:16:12','yyyy-mm-dd hh24:mi:ss') from dual;
------解决方案--------------------
SQL code
insert into table
select to_date('2010-02-21 9:16:12','yyyy-mm-dd hh24:mi:ss') from dual;
------解决方案-------------------- update tablename set ... where colname=to_char(sydate,'YYYY-MM-DD HH12:MI:SS' )