1、更新字符的时间; update zone_info set End_date = to_date('2009-07-06 10:34:27','YYYY-MM-DD hh24:mi:ss') where account = 12912796; 2、大小写转换; ///转换成小写 select * from account_table where lower(passport) = lower('abc13'); ///转换成大写 select * from account_table where UPPER(passport) = UPPER('abc13');