左补齐day_time字段,凑成6位数字 update TAXI_CASH_201608 set day_time=CONCAT(SUBSTR('00000' , LENGTH(day_time)) , day_time)