修改oralc表中一个日期型字段的格式,如2010.09.1 改成2010-09-01

  update products set products_time=substr(products_time,1,4)||'-'||substr(products_time,6,2)||'-'||substr(products_time,9,2)