update CASH_REPLENISH_PLAN set d_transaction_date = to_date('18-03-2016', 'dd-mm-yyyy');
update MOD_RECORD set c_mod_or_che_date = to_date('14-03-2016 11:44:03', 'dd-mm-yyyy hh24:mi:ss');
oracle日期时间数据类型字段更新例子
最新推荐文章于 2024-06-03 10:38:06 发布
update CASH_REPLENISH_PLAN set d_transaction_date = to_date('18-03-2016', 'dd-mm-yyyy');
update MOD_RECORD set c_mod_or_che_date = to_date('14-03-2016 11:44:03', 'dd-mm-yyyy hh24:mi:ss');