update products set products_time=substr(products_time,1,4)||'-'||substr(products_time,6,2)||'-'||substr(products_time,9,2)
转载于:https://www.cnblogs.com/Sophia_Cool/archive/2010/09/01/1814828.html
转载于:https://www.cnblogs.com/Sophia_Cool/archive/2010/09/01/1814828.html